- Joined
- Nov 26, 2011
- Messages
- 1
- Reaction score
- 0
Hiii,
I need help on how to increment the name of a worksheet in a COUNTIF function. I have a workbook with many worksheets each named after a class that I teach (grade 10-1 | grade 10-2| grade10-3...etc)
I have another worksheet where I want to bring the number of students who got a mark that is greater than 10 and for that I use the following COUNTIF function:
=COUNTIF('grade 10-1'!J$8:J$37,">10")
When I drag down to fill in the other cells below it, I couldn't get the name of the worksheet to change from grade 10-1 to grade 10-2 to grade 10-3 incrementally...
Does anyone have a clue on how to solve this, please?
I need help on how to increment the name of a worksheet in a COUNTIF function. I have a workbook with many worksheets each named after a class that I teach (grade 10-1 | grade 10-2| grade10-3...etc)
I have another worksheet where I want to bring the number of students who got a mark that is greater than 10 and for that I use the following COUNTIF function:
=COUNTIF('grade 10-1'!J$8:J$37,">10")
When I drag down to fill in the other cells below it, I couldn't get the name of the worksheet to change from grade 10-1 to grade 10-2 to grade 10-3 incrementally...
Does anyone have a clue on how to solve this, please?