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
Check out the Formula Handbook template!