Hi Sharon

Try
=COUNTIF(B2:AF2,"S")


--
Regards

Roger Govier


"Sharon" wrote in message
...
I currently have a spreadsheet set up to record staff holidays or
sickness.
But i would like the column AG to total how many times the letter S
appears
in any of 31 cells from colums B to AF. Each cell may have either
nothing
entered into it or S or H. Thanks for any help