SOLVED

SUMIF criteria help

Copper Contributor

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?

2 Replies
best response confirmed by mesmrc (Copper Contributor)
Solution

@mesmrc 

Adjust the ranges if needed.

 

=SUMPRODUCT(I2:I100,--((A2:A10="SKIP")+(B2:B100="SKIP")+(C2:C100="SKIP")<3))

wooh! hugely helpful, thanks so much Hans!
1 best response

Accepted Solutions
best response confirmed by mesmrc (Copper Contributor)
Solution

@mesmrc 

Adjust the ranges if needed.

 

=SUMPRODUCT(I2:I100,--((A2:A10="SKIP")+(B2:B100="SKIP")+(C2:C100="SKIP")<3))

View solution in original post