=COUNTIF(B1:B135, "1")

[Guest]

I'm getting an error message when I use this function, and it highlights the
"B135," part, including the comma like. The error is auf Deutsch, so I don't
fully understand it

 

[Bondi]

I'm getting an error message when I use this function, and it highlights the
"B135," part, including the comma like. The error is auf Deutsch, so I don't
fully understand it

Hi,

Try to change the , to ;

Regards,
Bondi

 

[Guest]

I copped that mistake, and it's still not working. It's saying that the whole
- b135, "1" - part is invalid, as if it thinks that that part is the range.
Any other ideas? I don't really use excel much, so I'm totally clueless!

 

[Guest]

how about =countif(B1:B135,1) ?

Eliminate the quotes. 1 is a value, not text.

Dave