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 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 27, 2014 at 04:51 PM
Mazzaropi Posts 1983 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
- How to increase wifi range - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Excel vba range find - Guide
- How to delete cells in word - Guide
- Excel arrow keys not moving cells - Guide
1 response
Mazzaropi
Posts
1983
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
