Question: Getting sub-totals by category

[Edward M. Baum]

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!!!

 

[Michael R Middleton]

Question: Getting sub-totals by categoryEdward -

Data | Subtotals ...

- Mike

www.mikemiddleton.com


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!!!

 

[Michael R Middleton]

Question: Getting sub-totals by categoryEdward -

Oops!

Data | Pivot Table Report would likely be more appropriate for your task.

- Mike

www.mikemiddleton.com


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!!!