Thread: Excel Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sharon Sharon is offline
external usenet poster
 
Posts: 183
Default Excel Formula

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