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
=Average(Sheet5!C3:C16)
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
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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Max,Originally Posted by Tenspeed39355
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
