B
Bill
How do I get the average of a group of years. Like 1999, 1998, 2000, etc.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
I think you need to provide much more detail to get a useful
reply.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
reply.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
B
Bob Phillips
maybe something like
=AVERAGE(ROW(INDIRECT("1998:2005")))
as an array formula, so commit with Ctrl-Shift-Enter
--
HTH
RP
(remove nothere from the email address if mailing direct)
=AVERAGE(ROW(INDIRECT("1998:2005")))
as an array formula, so commit with Ctrl-Shift-Enter
--
HTH
RP
(remove nothere from the email address if mailing direct)
H
Henry
Bill,
How do you want to treat fractions of a year?
For instance, the average of 1999 & 2000 is 1999.5 (if you're just treating
them as numbers)
Do you want this to show as 1999.5 or 1 July 1999?
Averaging dates is much easier as XL stores a date as a number.
Format cells A1 to A5 as date.
Format cells B1 to B5 as number (no decimal places)
In A1 to A4 put 4 random dates
In cell B1 put =A1
Drag the formula down to B4
In B5 put SUM(B1:B4)/4
In A5 put =B5
A5 will show the average date of the 4 you entered.
Henry
How do you want to treat fractions of a year?
For instance, the average of 1999 & 2000 is 1999.5 (if you're just treating
them as numbers)
Do you want this to show as 1999.5 or 1 July 1999?
Averaging dates is much easier as XL stores a date as a number.
Format cells A1 to A5 as date.
Format cells B1 to B5 as number (no decimal places)
In A1 to A4 put 4 random dates
In cell B1 put =A1
Drag the formula down to B4
In B5 put SUM(B1:B4)/4
In A5 put =B5
A5 will show the average date of the 4 you entered.
Henry