=sumproduct(--(a1:a10=2222),--(b1:b10="abcde"),(c1:c10))

Adjust the range, but don't use the whole column.

=sumproduct() likes to work with numbers. The -- stuff changes true and false
to 1 and 0.

enna49 wrote:

I am trying to SUM col3 if 2 cols meet a criteria eg If COL 1 = 2222 & col 2
= ABCDE then sum col3. Is this possible

Thanks

--

Dave Peterson