Sumif / Countif

Emma_w4tevr

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

Janie Walton

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

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.