Counting case-sensitive values withon a range of cells

[Jessika]

Hi everybody!!
Can anyone help me...Lets say from A!:A5, I have
A in A1
a in A2
A in A3
a in A4
A in A5How can I count the number of A and the number of a?
Please help,,, badly need it now..am stuck


Jessika

[VBA Noob]

Hi,

Try

=SUMPRODUCT(--(EXACT(A1:A5,UPPER("A"))))

=SUMPRODUCT(--(EXACT(A1:A5,Lower("A"))))

VBA Noob

[VBA Noob]

Sorry

Try

=SUMPRODUCT(LEN(A1:A5)-LEN(SUBSTITUTE(A1:A5,"a","")))

VBA Noob