Question: Getting sub-totals by category

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Edward M. Baum (embarc_at_flash.net)
Date: 01/29/05 

Date: Sat, 29 Jan 2005 23:47:29 GMT

I know this is a basic question. Iım using Excel as a DB to keep record of
my expenses for taxes. I assign a name to each account in an Œaccountı
column. Iıve been told thereıs a way to have Excel sort by account and give
a total for all the entries that have that account code.

Can you point me to how to do this?

Thanks!!!

Relevant Pages

  • Re: Excel Services error and Kerberos
    ... the same account towards SSAS will be used whatever ... I got it work with SSO! ... (SharedServices running Excel Services) ... In the group "Security Configuration" click at the link "Manage settings ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Accounting Reports in Access
    ... this was an Excel sheet. ... This is linked to the main information table using the account number ... you could build a report that groups by teach organization. ... I would then build a sub report that sums up all of the payments made by ...
    (microsoft.public.access.reports)
  • RE: Slow file access
    ... This issue does appear to be isolate to the one account. ... Other Excel and other file types seem to be okay. ... The problem occurs no matter which PC this user logs onto. ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Retrieve User Attributes (DisplayName & Description)
    ... some User Account attributes, if the User Account does in fact exist (E.g. ... Dim strTo, strRaceNo, strName, strSurname, strEMailAddress, strTPT_From, ... ' Open the Spreadsheet ... ' Bind to Excel object. ...
    (microsoft.public.scripting.vbscript)
  • Re: Prevent Duplicate Records
    ... using Excel 2007) so we need to define a specific range. ... I enter the same account number it will not let me. ... If Account Number being entered into Col A matches a exsisting record ... Private Sub Worksheet_Change ...
    (microsoft.public.excel.misc)