Thread: Sum IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K.R K.R is offline
external usenet poster
 
Posts: 1
Default Sum IF

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