Count if problems
COUNTIF and SUMIF are crappy functions,
they count the below regardless if text or numeric and
if you remove the quotations they do the same but use
a wildcard and it looks for text only
COUNTIF(A1:A10,"1")
--
Regards,
Peo Sjoblom
"T. Valko" wrote in message
...
That'll miss cells which contain just the single entry 1 (if a single
entry has not been formatted as text).
--
Biff
Microsoft Excel MVP
"Bob Phillips" wrote in message
...
=COUNTIF(A1:A14,"*1*").
--
__________________________________
HTH
Bob
"mjlunt" wrote in message
...
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
|