Try this:

=SUMPRODUCT(--($A$1:$A$100=2007),--($B$1:$B$100=1),--($B$11:$B$100<=3),$C$1:$C$100)

assumed the year information is in A1:A100 and the month information is in
B1:B100 and the amounts are in C1:C100

this is for the year 2007 but you can change to what ever year you want

this is for first quarter for other quarters you have to change =1 and <=3
to:
second quarter: =4 and <=6
third quarter: =7 and <=9
last quarter: =10 and <=12

Thanks,
--
Farhad Hodjat


"Prospect" wrote:

Hi
I have a list of expenditures and want to create a report that wil total
them by category in each quarter.

So far my list has headings of:
Year Month Category Amount

I would appreciate suggestions on how to set this up please!
--
David