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


--
bobthedinosaur
------------------------------------------------------------------------
bobthedinosaur's Profile: http://www.excelforum.com/member.php...o&userid=28160
View this thread: http://www.excelforum.com/showthread...hreadid=476825