Counting no. of times a value is entered in a column
I'm using this formula and the answer comes up 0. I want to count the no. of times 0 and 1 appear in a column.
=COUNTIFS([No. of mos. cash available]:[No. of mos. cash available], AND(CONTAINS("0", @cell), CONTAINS("1", @cell)))
Best Answer
-
Answered it myself. I was persistant that it didn't need to be that hard.
=COUNTIFS([No. of mos. cash available]:[No. of mos. cash available], <3)
Answers
-
I have a column where I want to count the number of months that rows have cash on hand. Row 1: 0, Row 2:6, Row 3: e.g. I have a pulldown menu of 0 to 12 and want to count all the rows that have 2, 1, or 0.
I would like to count all the values that are less than the value 3 (all in the same column)
Searching in the community i found:
=COUNTIFS(No. of mos. cash available: No. of mos. cash available, CONTAINS("0", @cell), No. of mos. cash available: No. of mos. cash available, CONTAINS("1", @cell), No. of mos. cash available: No. of mos. cash available, CONTAINS("2", @cell)))
Tried other variations--but nothing seems to work!
Any help is appreciated!
-
Answered it myself. I was persistant that it didn't need to be that hard.
=COUNTIFS([No. of mos. cash available]:[No. of mos. cash available], <3)
-
Hi Richard,
I'm glad you figured it out!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 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
Check out the Formula Handbook template!