Sumproduct Formula Help

H

Harley

=SUMPRODUCT((ISNUMBER(FIND({"FLH","FLT"},L2:L100)))*(M2:M100="N"),P2:p100


The two strings are creating an error? Formula works fine with one text
string. Anyway to resolve?

harley
 
D

daddylonglegs

I take in column L could contain FLT and/or FLH within other text?

Note that this formula could "double-count", e.g. if L3 = "FLT xxxFLH",
M3="N", P3=10 then the 10 would be added to the total twice.
 
Top