Hi Guys,
I have this fomula in a spread sheet and when I try to add another parameter it is not working, any suggestions?
=SUM(IF(ISNUMBER(MATCH(E14:E18,{"L","T","P","S","RH","SS","LL","PH"},0)),LOOKUP(E14:E18,{"L","T","P","S","RH","SS","LL","PH";1,1,1,1,1,1,1,1})))
I have this fomula in a spread sheet and when I try to add another parameter it is not working, any suggestions?
=SUM(IF(ISNUMBER(MATCH(E14:E18,{"L","T","P","S","RH","SS","LL","PH"},0)),LOOKUP(E14:E18,{"L","T","P","S","RH","SS","LL","PH";1,1,1,1,1,1,1,1})))