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.
CountIF using AND
Hi all,
Can anyone tell me what might be wrong with this function below?
=COUNTIF((AND([Field CSA]:[Field CSA],"Name"),([Status]:[Status],"TEMP")))
I need to count the occurrences where the Field CSA column has the word Name and where the status column has the word TEMP.
When each value appears in their respective columns on a given row, I need to count the occurrence of that on the sheet.
Thank you in advance for your help and assistance.
Scott
Comments
-
Try a COUNTIFS function instead: https://help.smartsheet.com/articles/775363-using-formulas#countifs
-
Thanks Shaine...
Like this?
=COUNTIFS(Field CSA:Field CSA, "Name", [Status]:[Status], "TEMP")
This formula returns #Unparsable. :-(
Any thoughts?
Scott
-
You need brackets around your "Field CSA" column (or any column name with spaces) when you reference it in a formula:
=COUNTIFS([Field CSA]:[Field CSA], "Name", Status:Status, "TEMP")
This counts any items that meet both criteria.
-
AH!
Thank you Shaine! Very much appreciated!
Scott
-
I followed the similar thought for my smartsheet but my still comes back with #unparsable. What should I do?
=COUNTIFS($Status$1:$Status$69,"Completed";$[Duplicate Project]$1:$[Duplicate Project]$69,"D")
-
I'm having the same issue referencing other sheet values. I am referencing two columns from another sheet. Any assistance would be extremely appreciated.
=COUNTIFS({Instant Incentive Distributor Tracking - A Range 2}, "PY8", {Instant Incentive Distributor Tracking - A Range 3}, "Yes")
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives