Want to add cells and return 1/2 if they don't equal a cell ERROR

Tabitha

=SUM(IF([Reel Stop]@row:[Quantity Scrapped]@row = [Reel Start]@row, 1, 2))

Jeff Reisman

Your SUM syntax is SUM(number1, [number2, ​...]), and it should be inside your IF, not outside. The IF syntax is IF(logical expression, true condition, false condition).

Try this:

=IF(SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, "YES", "NO")

Your logical expression is SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, true condition is "YES", false condition is "NO".

Jeff Reisman

Your SUM syntax is SUM(number1, [number2, ​...]), and it should be inside your IF, not outside. The IF syntax is IF(logical expression, true condition, false condition).

Try this:

=IF(SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, "YES", "NO")

Your logical expression is SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, true condition is "YES", false condition is "NO".

Tabitha

Thanks Jeff!