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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 27, 2014 at 04:51 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 27, 2014 at 04:51 PM
Related:
- Numerical value is range of cells has a text value
- If two cells match return value from third excel ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 27, 2014 at 04:51 PM
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
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