need execel formula

[kir]

If I put letters e.g. a in b2, b in b3, a in b4. I would like to kno
how to calculate the number of letters 'a' in b10, number of lette
'b' in b11,etc.

Thank

 

[Domenic]

Hi,

Try,

B10=SUMPRODUCT(--(B2:B4="a"))
B11=SUMPRODUCT(--(B2:B4="b"))

Hope this helps!

 

[Jason Morin]

B10:
=COUNTIF(B2:B4,"a")

B11:
=COUNTIF(B2:B4,"b")

HTH
Jason
Atlanta, GA

 

[kir]

Thank you, both formula worked. That's great

 

[kir]

Both formulas work, however, I have a problem if there is ab in on
column, it will not count the a unless it is on its own.

It is for a duty rota for about 30 staff who works 24 hours, e.g. a
morning, b= afternoon, c=night. However, there are shifts that are a
which is both morning and afternoon.

When balancing the rota I need to know at a quick glance how many a'
or b's there are as it gets change very often and need to b
rebalanced.

Thanks again