What is wrong with my COUNTIF formula?


I am not sure what is wrong with my very simple formula...

=COUNTIF(Quarter:Quarter, "Q1")

I have a list of 700 line items and am trying to add formula to total up a count of programs 'by quarter' in sheet summary and keep getting #imparseable or #invalid data type (if I add "quotes" outside Q1)

I am creating a new field for Q1, Q2, Q3, Q4 so I can have totals for each quarter to add this data to a dashboard.

Please help - see attached screen shot so you can see a part of my data. (Only other detail that might be important - this "Quarter" column is autocalculated based on the dates that are added in other columns. Not sure that should make a difference, but thought I'd mention it. I was able to successfully COUNTIF other columns that were populated in the same way based on data that was entered in other columns. But I've spent way too much time trying to trouble shoot and I'm sure it's some easy obvious solution that I am missing.

thank you for your help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!