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
- 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
- Excel formula to check if cell contains a date - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel 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
