With
Categories in Col_B
Amounts in Col_D

E1: Grocery
This formula sums all Col_D values where the corresponding Col_B value
matches the value in cell E1
F1: =SUMIF($B:$B,E1,$D:$D)

Alternatively, you could use a pivot table to automatically generate a list
of all Categories and their respective sums

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"K.R" wrote:

I have a spreadsheet where I track my monthly spending.
Column B is the type for example "Grocery"
And Column D is the dollar amount.
I would like to sum by category. That is, sum my grocery, gas etc all
seperately.
What formula can I use to sum cells in column D only if the corresponding
column B cell is "Grocery"

Please Help!!