Excel Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon - 23 Mar 2007 17:03 GMT

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

Reply to this Message

Roger Govier - 23 Mar 2007 17:08 GMT

Hi Sharon

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

Signature

Regards

Roger Govier

>I currently have a spreadsheet set up to record staff holidays or
>sickness.
[quoted text clipped - 3 lines]
> nothing
> entered into it or S or H. Thanks for any help

Reply to this Message