Excel Formula

[Sharon]

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

 

[Roger Govier]

Hi Sharon

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