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

edited 12/09/19 in Archived 2016 Posts

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?



This discussion has been closed.