| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
average age
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average age
What is your data (columns etc)? How is age of person held (years/months)?
"msiz" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average age
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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average age
If the age is in the same cell on each sheet, you can use a 3D reference such
as =AVERAGE(Sheet1:Sheet3!A3) Jerry "msiz" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average age
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. "msiz" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
average age
that's great - thanks for all the help :)
msiz "bj" wrote: 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. "msiz" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average doesn't average correctly? | Excel Discussion (Misc queries) | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
