Using Average command

[Tenspeed39355]

Good morning guys. I have several tabs in Excel that I am using. In tab6
I want to use the Average command to look over in Tab 5 and get the average of C3:C16. I have looked thru my command but am unable to find the right order. Can you send me the command to use? Thanks
Max

[Bob Phillips]

=Average(Sheet5!C3:C16)

[Tenspeed39355]

I tried using AVERAGE(Sheet6!C3:C16) that is not working. If I am in sheet 7 and I want to use the AVERAGE command to get some data from sheet6 what command do I use?
Max

[mdmackillop]

As with all such formulae, type "=AVERAGE(" into the cell, move to the sheet and select the cells you want, close the brackets and press enter. Excel will do the rest.

[lucas]

I tried using AVERAGE(Sheet6!C3:C16) that is not working. If I am in sheet 7 and I want to use the AVERAGE command to get some data from sheet6 what command do I use?
Max
Max,
Bob gave you the correct formula....remember it must have = in front of it of course. eg =Average(Sheet5!C3:C16)
Malcolms method also works.....

if your getting a #DIV/0! in the cell then you don't have any data in the range Sheet5!C3:C16

I'm going to quote Gerry here "that is not working" does not tell us much...so we're now guessing when you could tell us.