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

Richard C

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)))

No. of mos. cash available.png

Richard C

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)

Richard C

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

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.

Hi Richard,

I'm glad you figured it out!