Formula Help Count

Lisa Welch

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?

KevinPlut

You need to incorporate a condition into your counting formula. For your case, use COUNTIF.

=COUNTIF(Month:Month, <>0)

Lisa Welch

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,

KevinPlut

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

Lisa Welch

Thank you Kevin,

Yes, that worked and appreciate the clarification of the formula!