Nevermind on my second question as well. I got it. Thanks again.

"Peanut" wrote:

This works great, but oddly enough the customer value of "C" does not work.
If I change that same customer to another letter, it works just fine. Weird.

But now I have another question. Is there a way to count how many products
Customer A bought in a certain month? With this small of a data set, it is
easy to count by hand, but my data will end up being an indefinite length by
year end.

Thanks.


"T. Valko" wrote:

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?