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

Sum IF
 

On Sun, 27 Aug 2006 15:31:01 -0700, 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!!

=SUMIF(B:B,"Grocery",D:D)

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Sum IF
 

K.R,
here is one way,

=SUMIF(B1:B15,"Grocery",D1:D15)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

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

Sum IF
 

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

Sum IF
 

Thanks alot.
It Works!

"Richard Buttrey" wrote:

On Sun, 27 Aug 2006 15:31:01 -0700, 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!!

=SUMIF(B:B,"Grocery",D:D)

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Sum IF
 

Yes it worked. Thanks alot.

"Ron Coderre" wrote:

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

Sum IF
 

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