Counting those cells of a spicific range of multiple worksheets which can pass a logic

[elmoh3n]

Hello!!
I have an excel workbook which includes 27 worksheets. I want to count "F" column cells of those worksheet, based on those entries. I want to know how many of those are less than 10, how many of those are between 10-20 and how many of those are more than 20.
Can any body help me, please!?
Special thanks in advance.

 

[Weazel]

you'd need to make a list of the sheetnames somewhere out of the way.


Excel 2012

	A	B	C	D	E
sheet1
sheet2
sheet3

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFFF00"]Sheet Names[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00"]< 10[/TD]
[TD="bgcolor: #FFFF00"]> 10 <= 20[/TD]
[TD="bgcolor: #FFFF00"]> 20[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]C2[/TH]
[TD="align: left"]=SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),10))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=SUMPRODUCT(COUNTIFS(INDIRECT(" ' "&A2:$A4&" '!F:F"),">10",INDIRECT(" ' "&A2:A4&" '!F:F"),"<=20"))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]=SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),">20"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[elmoh3n]

you'd need to make a list of the sheetnames somewhere out of the way.


Excel 2012

	A	B	C	D	E
sheet1
sheet2
sheet3

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFFF00"]Sheet Names[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00"]< 10[/TD]
[TD="bgcolor: #FFFF00"]> 10 <= 20[/TD]
[TD="bgcolor: #FFFF00"]> 20[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]C2[/TH]
[TD="align: left"]=SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),10))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=SUMPRODUCT(COUNTIFS(INDIRECT(" ' "&A2:$A4&" '!F:F"),">10",INDIRECT(" ' "&A2:A4&" '!F:F"),"<=20"))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]E2[/TH]
[TD="align: left"]=SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),">20"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Ah, thank you, very interesting.