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 values from a column based on whether another column is empty or not
I'm trying to to sum values from the 'Value' column for a particular 'Reference number., but only if a third column ('Confirmation number') has a value. The actual value in the third column is not relevant, just whether it's been completed (confirmed) or not.
I've got as far as this
=SUMIFS(Value:Value, [Reference number]:[Reference number], "1659000166", [Confirmation number]:[Confirmation number], <>NULL)
The <>NULL is a guess to try to show what I would like to achieve.
Any ideas how I could do this?