I'm struggling to add an IF to a SUMPRODUCT with correct syntax. I want to achieve the following:
IF MATCH found in $A$93 and column A27:A38 ($A$93 and A27:A38 contain text) AND corresponding row in Column B:B = "I"
THEN, return value in corresponding row in Column E:E
IF Not, then calculate:
=sum($H$93*G98)
Can anyone help. Thanks.
Dan
IF MATCH found in $A$93 and column A27:A38 ($A$93 and A27:A38 contain text) AND corresponding row in Column B:B = "I"
THEN, return value in corresponding row in Column E:E
IF Not, then calculate:
=sum($H$93*G98)
Can anyone help. Thanks.
Dan
