average age

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
I have a spreadsheet with lots of different sheets, with info in them. I am
trying to calculate average ages of people listed in each sheet. can anyone
help?
thanks
msiz
 
Mon, 2 Jul 2007 03:52:09 -0700 from msiz
I have a spreadsheet with lots of different sheets, with info in them. I am
trying to calculate average ages of people listed in each sheet. can anyone
help?

You'll need to be a bit more precise about your requirements. But
assuming you've got their dates of birth in A1:A100, then
=TODAY() - AVERAGE(A1:A100)
will give you their average age in days.
 
If the age is in the same cell on each sheet, you can use a 3D reference such
as
=AVERAGE(Sheet1:Sheet3!A3)

Jerry
 
if the ages are listed in the sheets in the same cell on each sheet(c1?)
where you want to have the average
enter =average(
select the first sheet (Furthest to the left in the tab section) with an age
and select the cell with the age
hold down the shift key and select the last sheet (furthest to the right in
the tab section) with an age
type ) and hit enter

if the data is date of birth
find a common empty cell in the sheets with data
select the first sheet and holding down the shift key select the last sheet
enter in the predetermined empty cell
=datedif(dob_cell,today(),"y")

use this cell in the average age secion above.
 
that's great - thanks for all the help :)
msiz

bj said:
if the ages are listed in the sheets in the same cell on each sheet(c1?)
where you want to have the average
enter =average(
select the first sheet (Furthest to the left in the tab section) with an age
and select the cell with the age
hold down the shift key and select the last sheet (furthest to the right in
the tab section) with an age
type ) and hit enter

if the data is date of birth
find a common empty cell in the sheets with data
select the first sheet and holding down the shift key select the last sheet
enter in the predetermined empty cell
=datedif(dob_cell,today(),"y")

use this cell in the average age secion above.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vehicle age 2
adding cells 1
Calculating average ages 5
Vlookup using different sheets 3
adding cells 8
simple average question 2
Averaging a list of dates / ages 1
Average of dates of birth 3

Back
Top