Since you want to see all categories totalled separately, you should have a
look at pivot tables. Your example is a very simple pivot table, but if you
experiment with it on a simple application, you will find other uses for
this powerful tool.

--
Carlos

"K.R" wrote in message
...
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!!