I am trying to sum a set of columns if one condition does not exist.

blmccue

I have tried a couple of formulas with no luck. If the first three criteria have "Fail" then the overall score should be Fail; however if not then I want to add the scores of the other columns together. Here's what I've tried so far. and I get #INCORRECT ARGUMENT for the if statement and #UNPASEABLE for the sum statement.

=SUMIFS([AF-S1]@row, "Fail", , [AF-S2]@row, "Fail", , [AF-S3]@row, "Fail", , [Total Call Opening Score]@row + [Total Communication Score]@row + [Total Ownership Score]@row + [Total Closure Score]@row = [Total Customer Centricity Score]@row)

=IF(OR([AF-S1]@row, [AF-S2]@row, [AF-S3]@row, "Fail", SUM([Total Call Opening Score]@row, [Total Communication Score]@row, [Total Ownership Score]@row, [Total Closure Score]@row, [Total Customer Centricity Score]@row)))

blmccue

Hi Paul, thanks for taking the time to help! Here is a screenshot.

Paul Newcome

Are you able to provide screenshots for reference?

blmccue

Hi Paul, thanks for taking the time to help! Here is a screenshot.

Paul Newcome

Try this:

=IF(OR([AF-S1]@row = "Fail", [AF-S2]@row = "Fail", [AF-S3]@row = "Fail"), "Fail", SUM([1st Score Column]@row, [2nd Score Column]@row, [3rd Score Column]@row))

blmccue

Thank you that worked!

Paul Newcome

Happy to help. 👍️