Badly Needed community help

[Veltrex]

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.

 

[awoohaw]

Please get the xl2bb tool from the link above to post your samples.
here is a solution which is assuming the numbers are values and not text:

Some Mr Excel Questions.xlsx
	A	B
1	8.1	8
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
Sheet1

Cell Formulas
Range	Formula
B1	B1	=COUNTIF(A1:A10,">"&8)

 

[Peter_SSs]

Welcome to the MrExcel board!

Is one of theses what you are after?

23 01 23.xlsm
	A	B	C
1	Num	Group Count 1	Group Count 2
2	8.1	5	1
3	8.2	5	2
4	8.3	5	3
5	8.4	5	4
6	8.6	5	5
7	7.8
8	7.7
9	8.1	3	1
10	8.2	3	2
11	8.3	3	3
12
Above 8

Cell Formulas
Range	Formula
B2:B11	B2	=IF(A2>8,IF(N(A1)>8,B1,FIND(0,CONCAT(IF(A2:A$19>8,1,0),0))-1),"")
C2:C11	C2	=IF(A2>8,N(C1)+1,"")

 

[awoohaw]

or maybe this?

Some Mr Excel Questions.xlsx
	A	B
1
2	8.1	1
3	8.2	2
4	8.3	3
5	8.4	4
6	8.6	5
7	7.8
8	7.7
9	8.1	1
10	8.2	2
11	8.3	3
COUNTIF

Cell Formulas
Range	Formula
B2:B11	B2	=IF(A2>8,IF(N(B1)=0,1,N(B1)+1),"")

 

[awoohaw]

I duplicated what was above, so please ignore.

 

[Peter_SSs]

I duplicated what was above, so please ignore.

You've really got an extra bit in there that doesn't add anything. After all, if N(B1)=0 the red part would give 1 - but the blue part would do that anyway so the red part could be left out (which is what my column C formula does )

=IF(A2>8,IF(N(B1)=0,1,N(B1)+1),"")

 

[Veltrex]

Please get the xl2bb tool from the link above to post your samples.
here is a solution which is assuming the numbers are values and not text:

Some Mr Excel Questions.xlsx
	A	B
1	8.1	8
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
Sheet1

Cell Formulas
Range	Formula
B1	B1	=COUNTIF(A1:A10,">"&8)

Thank you awoohaw for the reply.. really appreciate it. But my

thank you guys for the effort. Sorry my english is bad. English is not my mother tongue. What i wanted to be is there is one cell that will count every cell value rhat has continuously more than 8 without breaking inbetween. The counter will reset once the value go below 8 and start counting again if there is cell value morethan 8.
Again thank you to your time for this..

 

[Peter_SSs]

What i wanted to be is there is one cell that will count every cell value rhat has continuously more than 8 without breaking inbetween.

Try this then. If this is still not what you want then please post the sample data and the expected result(s) with XL2BB so that we don't have to keep guessing what it is you want.

23 01 23.xlsm
	A	B
1	Num	Group Count
2	8.1
3	8.2
4	8.3
5	8.4
6	8.6	5
7	7.8
8	7.7
9	8.1
10	8.2
11	8.3	3
12
Above 8

Cell Formulas
Range	Formula
B2:B11	B2	=IF(AND(A2>8,A3<=8),COUNTIF(A$1:A2,">8")-SUM(B$1:B1),"")

 

[Veltrex]

Welcome to the MrExcel board!

Is one of theses what you are after?

23 01 23.xlsm
	A	B	C
1	Num	Group Count 1	Group Count 2
2	8.1	5	1
3	8.2	5	2
4	8.3	5	3
5	8.4	5	4
6	8.6	5	5
7	7.8
8	7.7
9	8.1	3	1
10	8.2	3	2
11	8.3	3	3
12
Above 8

Cell Formulas
Range	Formula
B2:B11	B2	=IF(A2>8,IF(N(A1)>8,B1,FIND(0,CONCAT(IF(A2:A$19>8,1,0),0))-1),"")
C2:C11	C2	=IF(A2>8,N(C1)+1,"")

Thank you sir.. struggling to install XL2bb for some reason. what i need is (please check the photo) one cell only that will count the cell values that has color. Its like A4:A8 the counter cell A1 will count as 5 because the cells has color. Counter cell A1 will reset back to zero because A9 has no color, counter cell A1 again count as 1 since A10 has color, counter again reset to zero since A11 has no color and start counting again because A12:A25 cell has color so on and so fort.

thank you in advance...

Please get the xl2bb tool from the link above to post your samples.
here is a solution which is assuming the numbers are values and not text:

Some Mr Excel Questions.xlsx
	A	B
1	8.1	8
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
Sheet1

Cell Formulas
Range	Formula
B1	B1	=COUNTIF(A1:A10,">"&8)

 

[awoohaw]

Thank you sir.. struggling to install XL2bb for some reason. what i need is (please check the photo) one cell only that will count the cell values that has color. Its like A4:A8 the counter cell A1 will count as 5 because the cells has color. Counter cell A1 will reset back to zero because A9 has no color, counter cell A1 again count as 1 since A10 has color, counter again reset to zero since A11 has no color and start counting again because A12:A25 cell has color so on and so fort.

thank you in advance...


View attachment 83532

I think @Peter_SSs answered what you want in thread #8.
Here is his solution again:

WorkBook1.xlsx
	A	B
1	Num	Group Count
2	8.1
3	8.2
4	8.3
5	8.4
6	8.6	5
7	7.8
8	7.7
9	8.1
10	8.2
11	8.3	3
Sheet1

Cell Formulas
Range	Formula
B2:B11	B2	=IF(AND(A2>8,A3<=8),COUNTIF(A$1:A2,">8")-SUM(B$1:B1),"")