Summarizing Items based on classifications

[Paul Bender]

Looking for some help on figuring out how to do something in Excel 97.
I'm using a spreadsheet to track my expenses and spending. Until now,
I've just been recording the date, amount, and an explanation, and
subtotalling each month. Now I'd like to add a category and total by
category for each month. I've added a new column for a category code
(A, B, C, etc). So I have Date, Amount, Category, and Explanation. I
don't know how to tell Excel to total each category by month on another
page...

Any help is appreciated...

Thanks in advance...

Paul

 

[Bob Phillips]

=SUMPRODUCT(--(MONTH(Sheet1!$A$2:$A$200)=1),--(Sheet1!$C$2:$C$200="A"),$B$2:
$B$200)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Paul Bender]

=SUMPRODUCT(--(MONTH(Sheet1!$A$2:$A$200)=1),--(Sheet1!$C$2:$C$200="A"),$B$2:$B$200)

Bob,

Would you mind explaining that a bit for me. Pardon me if I'm being
dumb. I tried looking at the help file for Excel and couldn't quite
come up with where you were trying to go...

Thank you very much!!!

Paul

 

[Dave Peterson]

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html