Counting no. of times a value is entered in a column
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
-
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)
Answers
-
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!
-
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)
-
Hi Richard,
I'm glad you figured it out!
Help Article Resources
Categories
Check out the Formula Handbook template!