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
- How to increase wifi range - Guide
- French numerical keyboard mac - 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
- Based on the values in cells b77 b88 ✓ - Excel Forum
- What function can automatically return the value in cell c77 - 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
