Re: Summarizing Items based on classifications

=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" <newsgroups@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:REDJg.2613$Cq4.608@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Looking for some help on figuring out how to do something in Excel 97.
I'm using a spread*** 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


.