Do you want to increment from Jun96 to Dec96? This could be done a couple of
ways but neither is very efficient and one of the ways results in a rather
long formula. If you only need Jun to Dec I think you'd be better off just
copying your current formula and manually changing the other sheet names.

--
Biff
Microsoft Excel MVP


"Excel Newbie" <Excel wrote in message
...

Hi all,

Does anyone know a way where I can change the sheet used in an AVERAGEIFS
formula in Excel when I attempt to autofill the formula down the column?
the
formula for cell

B2 is:AVERAGEIFS(jun96!AG:AG,jun96!AI:AI,5,jun96!AJ:A J,5)
For B3 I would like it to be:
AVERAGEIFS(jul96!AG:AG,jul96!AI:AI,5,jul96!AJ:AJ,5 )

Where my sheet names are jun96, jul96, aug96 etc? Currently, Excel just
copies the exact same formula when I attemp to autofill.

Thanks!