I was afraid of that. See Dave's reply, it'll work

--
Biff
Microsoft Excel MVP


"Excel Newbie" wrote in message
...
Thanks for the repy! Unfortunately, I have to do this for every month
until
june 2006 for various combinations of AI and AJ values. If I had a
formula, I
could try to manipulate it for the other combinaitons.

"T. Valko" wrote:

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!