Average

  • Thread starter Thread starter mohdhu
  • Start date Start date
M

mohdhu

Hello all,
I'm very new to this group. I have a question that might turn out to be
very silly. How do you calculate the Average for data across 3 separate
xls files (or across 3 sheets of on worksheet)? I have data collected
from 10 subjects, each having 3 repetitions of exactly the same data. I
need to get the average for every subject. Instead of cutting and
pasting, then getting the average within every sheet, is there a way of
doing this automatically, across the three repetitions?
Thanks a lot!
mohdhu
 
Long-hand I think

=(SUM('[Subject Book1.xls]Sheet1'!$A$1:$A$10)+SUM('[Subject
Book2.xls]Sheet1'!$A$1:$A$10)+SUM('[Subject
Book3.xls]Sheet1'!$A$1:$A$10))/(COUNT('[Subject
Book1.xls]Sheet1'!$A$1:$A$10)+COUNT('[Subject
Book2.xls]Sheet1'!$A$1:$A$10)+COUNT('[Subject Book3.xls]Sheet1'!$A$1:$A$10))

where A1:A10 is the rang to average.
 
Back
Top