May 17 2021 02:29 PM
I'm trying to get the sum of numbers in column I, but exclude rows from that sum if the word "SKIP" is listed in Columns A, B, and C of a given row. I don't want the number excluded from the sum if "SKIP" appears in one or two of those Columns, only if it appears in all three. Can someone help me write that formula?
May 17 2021 02:40 PM
SolutionAdjust the ranges if needed.
=SUMPRODUCT(I2:I100,--((A2:A10="SKIP")+(B2:B100="SKIP")+(C2:C100="SKIP")<3))
May 17 2021 02:40 PM
SolutionAdjust the ranges if needed.
=SUMPRODUCT(I2:I100,--((A2:A10="SKIP")+(B2:B100="SKIP")+(C2:C100="SKIP")<3))