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