sum if (problem: number text

  • Thread starter Thread starter chrismania
  • Start date Start date
C

chrismania

HI guys
I have following structure ot table
A B C
75% 3 1
75% 5 Won
Click to expand...

I want to sum column B if there is >75% in column a and a number in
column c in the same row. In this case it would be 3.
Thereby >75% should be treated as a text.

Thanks
Christopher
 
=SUMPRODUCT((A2:A20=">75")*(ISNUMBER(C2:C20)),B2:B20)

or

=SUMPRODUCT(--(A2:A20=">75"),--ISNUMBER(C2:C20),B2:B20)
 
Back
Top