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

dfo222
dfo222
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?

Tags:

Comments

This discussion has been closed.