Try this:

A15 = customer
B15 = month

=SUMIF(B2:B7,A15,INDEX(C2:F7,,MATCH(B15,C1:F1,0)))

--
Biff
Microsoft Excel MVP


"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?