Numerical value is range of cells has a text value

Closed
craig2014
Posts
1
Registration date
Friday June 27, 2014
Status
Member
Last seen
June 27, 2014
- Jun 27, 2014 at 06:49 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Jun 27, 2014 at 04:51 PM
Hi guys,

This is for a holiday rota. if any sell has a 'h' in it I would like to total up the h's in a cell at the end as a numerical value of how many days have been taken off. any ideas?

Cheers,
Craig

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jun 27, 2014 at 04:51 PM
craig2014, Good evening.

I believe that you can use a COUNTIF Function to do this job for you.

Suppose you have a range of days off. A4:M4

You can count how many H are in the range.
O4 --> COUNTIF(A4:M4,"h")

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0