=COUNTIF(B1:B135, "1")

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Joyce said:
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
Click to expand...

Hi,

Try to change the , to ;

Regards,
Bondi
 
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!
 
Back
Top