function using cells from multiple worksheets

[Roz]

I have four worksheets saved under one name. I need to
average a cell from each worksheet.
I've tried everything-can't get it to work
Thanks ahead

 

[Andy Brown]

What exactly do you mean by

saved under one name.

???

Can you post an example of something you tried?

Did you try something like
=AVERAGE(Sheet2!A1,Sheet3!A1,Sheet4!A1,Sheet5!A1)
???

Rgds,
Andy

 

[Roz]

Yes I tried =average(sheet1!:sheet4!,Q3)
is that the same?
I'll try what you sent to me and thanks
Roz

 

[Andy Brown]

Yes I tried =average(sheet1!:sheet4!,Q3)

Try =AVERAGE(Sheet1:Sheet4!Q3)

Rgds,
Andy

 

[ROZ]

i TRIED THIS FUNCTION DON AND IT DIDN'T WORK EITHER?
rOZ THANKS

 

[Peo Sjoblom]

It's considered rude to use caps

=AVERAGE(Sheet1:Sheet4!Q3)

should work

 

[Andy Brown]

Seriously, this is one (other) reason I believe that default behaviour for
inserting sheets should be to the right of current tab. But that's just me.

Rgds,
Andy

 

[roz]

sorry for using caps-yelling ? i guess?
thanks ill try yours -does it matter where i place the
function?
Roz