I realized what I did. I forgot to limit the J column.

Thank you so much for your help.

"Pete_UK" wrote:

It's always useful to post the formula you tried. Have a go with this
one:

=SUMPRODUCT((A1:A5=123)*(B1:B5="groupA")*(C1:C5))

If the first column contains text values rather than real numbers then
you will have to put the 123 in quotes, like this - "123"

You can't use complete columns (unless you have XL 2007).

Hope this helps.

Pete

On Jan 18, 6:54 pm, mwear wrote:
I'm trying to sum a row if it meets two different criteria. Here's an
example. Here I would try and add column C if column A was 123 and column B
was group A. Or something similar. I tried to used sumproduct (reading
other responses to similar questions) but I get #NUM! error. Any ideas?

A B C
1 123 group A 5
2 456 group D 10
3 123 group B 14
4 456 group A 7
5 123 group C 6