Count if problems
This formula will count 1s
=SUMPRODUCT(--ISNUMBER(FIND("1,",A1:A14&",")))
It can be easily changed to count 2 or 12 without counting the 2 in 12.....
"wd" wrote:
Your formula should state: =COUNTIF(A1:A14,2) then your answer will be 5.
"mjlunt" wrote:
I am trying to count the number of cells that contain the number 1 within the
data below. The formula that I am using is =COUNTIF(A1:A14,"1"). With this
formula the value returned to me is 2 however it should be 5. Please Help!!
2,3
2
2
1,2,3
3
2
2,3
1,2
2
1,2
3
1
1
2
|