ExcelBanter - Excel Formula

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel Formula (https://www.excelbanter.com/new-users-excel/136139-excel-formula.html)

Sharon

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

Roger Govier

Excel Formula

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

All times are GMT +1. The time now is 10:55 AM.