Do I use the count or countif formula
I am trying to create a formula that pulls a count based on data in two columns. Example: I am trying to set up a sheet summary with counts for specific information. Column 1 is a text/number column and is titled "AB Comments" the second column is also a text/number column is titled "status"
is is possible for me to tell it if column 1 (AB comments) reads "expired" and column 2 (Status) reads "keep" that is will count all that meet that criteria throughout the entire sheet in those two columns?
Best Answer
-
You would use a COUNTIFS for this one.
=COUNTIFS([AB Comments]:[AB Comments], "Expired", Status:Status, "Keep")
Answers
-
You would use a COUNTIFS for this one.
=COUNTIFS([AB Comments]:[AB Comments], "Expired", Status:Status, "Keep")
-
Thank you so much Paul! I was putting the brackets in the wrong place.🙂
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 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!