Why is it not counting "MTS" in my sheet summary
If you see in the PROJECTS column there are multiple entries. "MTS" is one of those options, but it made me realize its not counting it if there are multiple entries. Here is my formula:
=COUNTIFS(Projects:Projects, "MTS")
How do I get it to see the MTS in the PROJECTS column?
Ricky T
Gov Contractor for USSF
Best Answer
-
Hi @RickyT
See if this formula helps:
=COUNTIF(Projects:Projects, CONTAINS("MTS", @cell))
Hope this helps!
Answers
-
Hi @RickyT
See if this formula helps:
=COUNTIF(Projects:Projects, CONTAINS("MTS", @cell))
Hope this helps!
-
@ker9 thanks for the solution, that worked. Can you explain why the @cell part works? I understand it searching for the MTS with contains but the last bit has me confused. My guess is that the statement contains is not aware of the column we a searching since its outside the statement.
Ricky T
Gov Contractor for USSF
-
@RickyT - this help article will explain it better than me
"The @cell argument performs a calculation on each row at the same time that the primary function (SUMIF for example) is evaluating the criteria in the range, making your formula more efficient."
Hope this helps :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!