Formula Help Count

Lisa Welch
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?

Answers

  • KevinPlut
    KevinPlut ✭✭✭

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

    =COUNTIF(Month:Month, <>0)

  • Lisa Welch
    Lisa Welch ✭✭✭✭

    Thank you Kevin,

    I'm missing something in the formula.

    I have =COUNT([Jan '23]@row:[Dec '23]@row)

    image.png

    If someone enters $0 in Jan, Feb, Mar, Apr, May, Jun, Jul or Aug I don't want it to count.

    Thanks,

  • KevinPlut
    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
    Lisa Welch ✭✭✭✭

    Thank you Kevin,

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!