Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Sum only the number values, excluding #INVALID OPERATION

Accounts Manager
Accounts Manager ✭
edited 12/09/19 in Archived 2017 Posts

Hi there,

I am currently looking to set up a formula, which will sum up the numerical children value only. There are few cells in the range with "#INVALID OPERATION" (as the result of another formula from a different sheet, this will be resolved once we get all the information from our supplier in the future) and because of them, I am unable to just use =sum(children()) to get the value.

Any help would be appreciated and thanks in advance.

· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    AM,

    If I understand correctly, formulas that reference cells that have an error will also have an error. You need to correct or mask the #INVALID OPERATION errors to get the SUM working properly.

    Take a look at IFERROR() to mask the errors until the data comes in.

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories