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 / Countif

edited 12/09/19 in Archived 2017 Posts

Hi All,

Still new to SmartSheet so help would be appreciated 

I am trying to sum a column if another column contains specific text "street lighting"

I have come to 

=COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date])

but it comes back with Unparseable and I am lost, It's probably something simple that i am just not seeing. 

Thanks in advance


  • There's a couple of points to note:

    "Street Lighting,"  your comma is inside the brackets, suspect you don't want it to look for Street Lighting, but just Street Lighting and the formula expects a ',' after the first variable.

    COUNTIF only expects 2 variables.  So you are asking it to look at the column 'Team' for the text "Street Lighting," and it will return the total number of "Street Lighting," entries in your whole column.   You can see this by deleting the Past Due Date part and correcting your comma.  

    Am not sure exactly what figure you want to show.  Is is total number of days Past Due Date but only for those rows with team = " Street Lighting" ?

    If so, I suspect you need SUMIF rather than COUNTIF, which allows you to add your second column to add up. 

    Hope this helps. 

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    I agree with Janie. Sumifs appears to be the formula you are looking for: https://help.smartsheet.com/function/sumif

    Try: =SUMIF(Team:Team, "Street Lighting", [Past Due Date]:[Past Due Date])

    Your comma was in your quotation marks and you had additional parenthesis in there. Hopefully, that is what you were looking for. 

This discussion has been closed.