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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!