scanning a table?

[bobthedinosaur]

ok so here's what ive got

table of accouting stuff
4 columns
column 1 : Date
column 2 : Category (eg. groceries, laundry, allowance)
column 3 : shop name
column 4 : amount in dollars

and then a whole bunch of rows with a variable for each column

what i want to do is make a cell with a formula that will add up all
the amounts in dollars of a certain category

eg. if a row's category value is groceries, then i want that amount in
dollars for that row to be added to the value in dollars in a cell that
adds up all the amounts for every row where the category is groceries

hope i put it clear enough...

can this be done in excel?

thanks in advance

 

[Roger Govier]

Hi Bob

Your data is ideal for summary with a Pivot Table.
This would allow you to easily summarise your data by Category (and by Month
if you want).

For help on how to set up Pivot Tables take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm


Regards

Roger Govier

 

[bobthedinosaur]

Thanks Guys