have numbered tabs for worksheet names in my workbook and have created a summary sheet that computes from each sheet. Cannot get the @#$@$ formula to let me mathematically change the sheet name tho. Would like to copy and paste one row of formulas for all 50 rows of the summary.
eg:
COUNTIF('8'!$G$3:$G$143, "gary")
would count the occurrences in sheet 8.
I'd _like_ to have it be
COUNTIF('prevrowval+1'!$G$3:$G$143, "gary")
where prevrowval starts as 0 (a constant), and the first actual row of the table ends up with the value of 0+1 in the formula, corresponding to sheet named 1 in my workbbook.
Stupid question I know but I can't figure it out without having to program in VB and I _really_ think there's an easier way.
eg:
COUNTIF('8'!$G$3:$G$143, "gary")
would count the occurrences in sheet 8.
I'd _like_ to have it be
COUNTIF('prevrowval+1'!$G$3:$G$143, "gary")
where prevrowval starts as 0 (a constant), and the first actual row of the table ends up with the value of 0+1 in the formula, corresponding to sheet named 1 in my workbbook.
Stupid question I know but I can't figure it out without having to program in VB and I _really_ think there's an easier way.