Badly Needed community help

Veltrex

New Member
Joined
Jan 22, 2023
Messages
13
Office Version
  1. 2019
Platform
  1. Windows
How do i count cell values in range that are continuously

Example: Column A was set to count only values more than 8.0. From #1-5 it would count 5, then #6&7 not included, then at number 8 counting start again as 1.
1. 8.1
2. 8.2
3. 8.3
4. 8.4
5. 8.6
6. 7.8
7. 7.7
8. 8.1
9. 8.2
10. 8.3
Guys can you help me what kind of formula should i use.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
I'm glad somebody figured out the requirement. 😎

Simply stated it would have been:
"I want to count how many consecutive numbers >=8 are at the bottom of each column" ;)

Regarding the formula suggested in post #28:
Since MIN(ROW(B4:B13)) will always be the B4 row number, that formula can be simplified as follows.

23 01 24.xlsm
BCDEFGHI
3312100210
48.027.968.327.838.158.018.338.22
57.628.177.998.327.548.187.898.22
67.558.488.187.857.777.998.138.22
77.998.228.338.018.297.948.098.22
87.917.997.977.658.38.298.028.22
98.387.627.678.268.198.377.748.22
107.878.27.788.477.648.487.558.22
1188.287.68.158.58.217.628.22
128.017.848.057.737.998.048.238.22
138.258.298.48.177.637.918.448.22
Count
Cell Formulas
RangeFormula
B3:I3B3=ROWS(B4:B13)-MAX((ROW(B4:B13)-ROW(B4)+1)*(B4:B13<8))
 
Last edited:
Upvote 0
Solution

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top