Can I do this across different worksheets? My column A, B, and C would be on
one worksheet and my references and answer would be another. Because, if I
copy the table and your formula it works, but when I transfer it to what I
need, it still comes up with an error.

Thanks for the quick response!!

"Mike H" wrote:

Sumproduct does it for me

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

Mike

"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