sumif

H

Harley

I need:

Sum Column C if Column A contains "XL" using Find, and Column B = "N". Can
you combine sumif and find?

thanks,

harley
 
P

Peo Sjoblom

=SUMPRODUCT(--(A2:A100="XL"),--(B2:B100="N"),C2:C100)

or if you really mean that XL is part of a string in the cell

=SUMPRODUCT(--(ISNUMBER(FIND("XL",A2:A100))),--(B2:B100="N"),C2:C100)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
Top