Count if problems
COUNTIF and SUMIF
They sure are loaded with nuance, especially COUNTIF.
--
Biff
Microsoft Excel MVP
"Peo Sjoblom" wrote in message
...
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
|