Formula Help Count
I have a column "month count" that counts how many months there is a value in the cell. I DON'T want it to count if the value is $0.
How do I write that?
Answers
-
You need to incorporate a condition into your counting formula. For your case, use COUNTIF.
=COUNTIF(Month:Month, <>0)
-
Thank you Kevin,
I'm missing something in the formula.
I have =COUNT([Jan '23]@row:[Dec '23]@row)
If someone enters $0 in Jan, Feb, Mar, Apr, May, Jun, Jul or Aug I don't want it to count.
Thanks,
-
Lisa, you are missing the "if" portion of your formula. I find it helpful to think of your written word and convert to the formula. As you mentioned, If someone enters $0 in Jan, Feb, Mar, Apr, May, Jun, Jul or Aug I don't want it to count.
=COUNTIF([Jan '23]@row:[Dec '23]@row, <> 0)
Hope that helps
-
Thank you Kevin,
Yes, that worked and appreciate the clarification of the formula!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!