sum text in vertical + horizontal columns

[russt]

I am producing a rota for my workplace.I can sum up the amount of shift
staff do horizontally( left to right) using the sum function.Howeve
what i want to do at the bottom of each column is add the number o
staff on duty.I can do this using the sum function but it adds up al
the letters i have in each column.EG H=Holiday so when a H is on th
rota i dont want it to add to my total at the bottom of the colum
D=Duty i have 4 staff on each night so in each column i could have
Duty 1 on H and 1 S off sick i now get a total of 6 when i really wan
it so show 4 automatically as i want the H & S not to be counted.Coul
someone please tell me a simple plain language way of doing tis if i
is possible

 

[Bernie Deitrick]

Russ,

Look in help for the COUNTIF function, used like this:

=COUNTIF(A:A,"Duty")

HTH,
Bernie
MS Excel MVP

 

[russt]

thnx i will tr