Counting no. of times a value is entered in a column

Options

I'm using this formula and the answer comes up 0. I want to count the no. of times 0 and 1 appear in a column.

=COUNTIFS([No. of mos. cash available]:[No. of mos. cash available], AND(CONTAINS("0", @cell), CONTAINS("1", @cell)))


Best Answer

Answers

  • Richard C
    Richard C ✭✭
    edited 04/04/20
    Options

    I have a column where I want to count the number of months that rows have cash on hand. Row 1: 0, Row 2:6, Row 3: e.g. I have a pulldown menu of 0 to 12 and want to count all the rows that have 2, 1, or 0.

    I would like to count all the values that are less than the value 3 (all in the same column)

    Searching in the community i found:

    =COUNTIFS(No. of mos. cash available: No. of mos. cash available, CONTAINS("0", @cell), No. of mos. cash available: No. of mos. cash available, CONTAINS("1", @cell), No. of mos. cash available: No. of mos. cash available, CONTAINS("2", @cell)))

    Tried other variations--but nothing seems to work!

    Any help is appreciated!

  • Richard C
    Richard C ✭✭
    Answer ✓
    Options

    Answered it myself. I was persistant that it didn't need to be that hard.

    =COUNTIFS([No. of mos. cash available]:[No. of mos. cash available], <3)

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi Richard,

    I'm glad you figured it out!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!