excel countif

[johngav]

Hello all

Assume i have the following excel sheet


cell value
A1 a
A2 a
A3 a
A4 A
A5 A

I want to insert a funtion in A6 which will count how many cells have a capital A .
If i use COUNTIF(A1:A5,="A") the result will be 5 .It also counts thw minuscule a's . How can i fix this ?

Thanks a lot

[Petef56]

Originally Posted by johngav Hello all Assume i have the following excel sheet cell value A1 a A2 a A3 a A4 A A5 A I want to insert a funtion in A6 which will count how many cells have a capital A .

The only way I can find to get it to count as you desrie is to add the following
formulas to all the 5 cells in column B...

=code(A1)
=code(A2)
=code(A3)
=code(A4)
=code(A5)

The above formula will produce... 97 for "a" or 65 for "A"

Then in cell A6 enter formula...

=COUNTIF(B1:B5,"65")


You may optionally hide the entire Column B to keep things looking clean.


---pete---