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.

SUMIF with check mark

edited 12/09/19 in Archived 2017 Posts

I have a column (Have we paid for this container?) and it contains checkmarks. I want to add up the total cost in another column (Cost) IF the checkmark is checked in the other column. This is what I have come up with, I get the #Unparseable error. Where am I going wrong? 




=SUMIF([Have we paid for this container?]1:[Have we paid for this container?]100, 1)([Cost]1:[Cost]100)





This discussion has been closed.