Countif formula Month
I have a Month column with multi-select properties for 3 months, September, October, and November. I preparing a metrics sheet and for some reason my countif formula is not calculating appropriately.
When I run the filter on my sheet, here are the values returned for each month:
September =30
October = 40
November = 26
When I write the formula on my metrics sheet, it's returning the following
=COUNTIF({Month}, "September") - I get 12
=COUNTIF({Month}, "October") - I get 21
=COUNTIF({Month}, "November") - I get 9
Am I doing something wrong here?
Answers
-
Hi @jgneely72151,
Your formula is only finding the cells which have only that single month in. For a multi-select column you would need a formula like this to see the ones which have multiple values including the one you're after:
=COUNTIF({Month}, CONTAINS("September",@cell))
Hope this helps, but if you've any issues then just post! 😊
-
Greetings @jgneely72151,
I agree with Nick on the solution but wanted to provide a complete formula.
=COUNTIF(Month:Month, CONTAINS("September",@cell))
I hope this helps and adds to Nick's answer.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
Thanks to you both! I kept saying there has to be a "contain" function and was about to check and got side-tracked. Thanks again for coming to my rescue because I got to get this dashboard up and running ASAP. This is most helpful!☺️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!