=SUMPRODUCT((B2:B7="A")*(MONTH(C1:F1)=1)*(C2:F7))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Peanut" wrote in message
...
In Excel 2003, I need to sum some information with multiple criteria, but
there is an extra spin on it. Here is my data:

Transaction Amount
Category Customer Jan Feb Mar Apr YTD
Pizza A 20 15 23 39 97
B 15 12 9 10 46
C 25 25 30 10 90
Drinks A 10 5 8 12 35
B 10 8 10 10 38
C 15 20 12 19 66

I need to create a report that SUMs the total amount spent (regardless of
whether it is pizza or drinks) by Customer A in January (or any other
month
that I specify). Essentially, I have two criteria - one in a row and one
in
a column. Is this possible?