Counting text characters in a row

[Dargo]

This problem is likely very simple however I'm new to speadsheets.
I've created a spresdsheet to record attendace at work. in each row
have an "H" or "S" to denote holiday or sickness respectively, agains
each name.
How do I count the number of "H's" in a row to tot up the number o
days holiday taken.
Sorry if this is very basic, but so is my spreadsheet knowledge.
Ala

 

[Zakir Ulla]

Hi ,

*This problem is likely very simple however I'm new to speadsheets.
I've created a spresdsheet to record attendace at work. in each row
have an "H" or "S" to denote holiday or sickness respectively
against each name.
How do I count the number of "H's" in a row to tot up the number o
days holiday taken.
Sorry if this is very basic, but so is my spreadsheet knowledge.
Alan *

You can use the "Countif" Function, giving the Range (rows in you
case) and criteria ("H")

=COUNTIF(range,criteria)
=COUNTIF(A1:E1,"H")


Regards,
Zakir Ull

 

[Dargo]

Thank you Zakir, appreciate your help

Ala

 

[Guest]

in the row below, say your data starts at A1, then in cell
A2 put =if(A1="H",1,0) and copy and paste that to each
cell to be used in row 1. at the end of row 2, sum all of
row 2 and that will be your number of holidays. You can
do the same for sickdays looking for s or S. Look out for
case!