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
1	Sheet Names		< 10	> 10 <= 20	> 20
2	sheet1		5	4	1
3	sheet2
4	sheet3

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),10)) D2 =SUMPRODUCT(COUNTIFS(INDIRECT(" ' "&A2:$A4&" '!F:F"),">10",INDIRECT(" ' "&A2:A4&" '!F:F"),"<=20")) E2 =SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),">20")) <tbody> </tbody>

<tbody>
</tbody>

 

[elmoh3n]

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


Excel 2012

	A	B	C	D	E
1	Sheet Names		< 10	> 10 <= 20	> 20
2	sheet1		5	4	1
3	sheet2
4	sheet3

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),10)) D2 =SUMPRODUCT(COUNTIFS(INDIRECT(" ' "&A2:$A4&" '!F:F"),">10",INDIRECT(" ' "&A2:A4&" '!F:F"),"<=20")) E2 =SUMPRODUCT(COUNTIF(INDIRECT(" ' "&A2:A4&" '!F:F"),">20")) <tbody> </tbody>

<tbody>
</tbody>

Ah, thank you, very interesting.