need execel formula

K

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
 
D

Domenic

Hi,

Try,

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

Hope this helps!
 
K

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
 
Top