Sum cells not equal to errors

The SUM function does not return a sum if any of the cells contain errors. You can use "=SUMIF("A2:A10",<>"#VALUE!")".
{=SUM(IF(ISERROR(CellRange),"",CellRange))} = 623

Built-in Functions

SUM - The total value of the numbers in a list, table or cell range.
IF - The value based on whether a certain condition is True or False.
ISERROR - The value True or False depending if the value is an error.
SUMIF - (SUMIFS) The total value of the numbers that satisfies one condition.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top