Twitter | Facebook | Sign in | Sign up
Your Qna     New Questions     About Qna
EQNA is a growing interactive people-knowledge network with more than 120,000 questions and 450,000 answers from over 55,000 members worldwide. With all friendly functions, EQNA will be a fun place to join, share and discover knowledge, an open net space allowing you to connect with other people having specialized knowledge or ones with same interests to yours. EQNA login features secured logins using Twitter and Facebook enable you to place questions without sharing your personal information to us. Lets get out and join our community today!
Ask a Question
Dan

Can do I Averaging between spreadsheets in Excel 2003

I am accruing numerical data on separate Spreadsheets and wish to run an average over last three months.
Answer this question
David:

Try:
Average(SheetName!A1:A10)
Assuming the block is in A1 through A10

Ed:

I don't see why not. Formulas don't really care where the data is coming from.

Dan:

Thank you. How do I do that???

Ed:

Just open all the spreadsheets where the data is coming from.
In the Cell where you want to put the average in, enter
=average(
Then, with the mouse, select the range in the first spreadsheet
press the comma key (,)
Then select the range in the second spreadsheet with the mouse, and press comma
...repeat until you have all the data you want in the average formula
Close the function by pressing )
Then hit enter to enter the formula.
The process is really the same, no matter where the data is coming from....always start with =, then if you are using a function name, enter it and use ( to open the parameters, select the data with the mouse or keyboard, and close the parameters with the ). This works on the same spreadsheet, different tabs, or different files.

Answer:
Text ColorBackground Color
BoldItalicUnderline
LeftCenterRightJustify
Ordered ListBulleted List
IndentOutdent
Horizontal Rule
SubscriptSuperscript
HyperlinkImage
Design ModeDesign
Html ModeHtml
 

Top Question And Answer

  • Would you support a free trade agreement between the U.S. and the BRIC states?
  • Shortest distance between multiple points?
  • Set up wireless bridge between two wired networks.
  • your playing a number guessing game with a friend his/her number is between 1 and 1,000,000...
  • A co-worker just gave me 3 BBQ Ribs & 3 Chicken breasts...between 4 guys how should they be split?
  • I even tried to ask for a peace between a person.I'm the 1 who gets the bashing,5-6hrs. ago I tried
  • what is the difference between letters and charecters?
  • Please recommend a fast laptop for business (logon to domains) recalc large spreadsheets quickly.
  • How does the use of Spreadsheets help organisations look after their finances budgets
  • What are the odds anyone could possibly figure out how to use spreadsheets ??
  • Is there a way to convert Microsoft databases to Excel spreadsheets without retyping it all?
  • what will my kids look like
  • amoung
  • mymetro
  • little mermaid cover
  • what does cod mean
  • krogerworks.com
  • http://mymedia.axcess.net/photo
  • worksforme.ca
  • medicad
  • what is socialization
  • protoge
  • pepole
  • james's or james
  • where does taurine come from
  • dkl marketing
  • what is socialization
  • lego blueprints
  • how old is queen elizabeth
  • notwithstanding the foregoing
  • interpert
  • norcolut
  • What The Hell Is The Problem today with QnA?
  • I installed a new hard drive on my Dell Dimension 8400. It appeared to partition ok and
  • Is there a way to install Live Wire on my computer with out joining a club and with no fees to pay?
  • Why do a lot of students have to handwrite?
  • How do I unlock my computer? I don't have a book for reference
  • what is the proxy and how can i use it
  • How long does HP take to ship a notebook pc to you?
  • how would i go about cleaning up my hard drive?
  • Is anybody experiencing PROBLEM'S with QnA right now!
  • i want to know how to write an excellent resume
  • I want to create facebook account
  • I enabled Windows Disk protection in Steady state and now my machine is thrown into endless loops.
  • how do I get control of my computer back? Windows xp no access to tools or programs
  • how do i sweep the hard disk?
  • What email addresses are being kept in Outlook Auto-Complete Cache?
    • 123456789101112131415161718192021222324252627282930

    New Question

  • I want to create facebook account
  • Do's and dont's in typing
  • How can i advertise my business on net
  • Mymedia Access Net Photo
  • where can i find a free pixel shader 2.0

    • TAG

    averaging, between, spreadsheets

    Hot Topics

    Style Business Car Education Entertainment Games Health News Travel Restaurant Flight Hotel Visa Embassy
    * QNA privacy * * Terms of Use * * Advertise * * RSS