Using your example (in cells A1:C5):
Max =SUMPRODUCT(MAX((B2:B5)+(C2:C5)/12))
Min =SUMPRODUCT(MIN((B2:B5)+(C2:C5)/12))
Avg =SUMPRODUCT(((B2:B5)+(C2:C5)/12))/COUNT(B2:B5)
Or you could use array formulas (committed with [Ctrl]+[Shift]+[Enter]):
Max =MAX((B2:B5)+(C2:C5)/12)
Min =MIN((B2:B5)+(C2:C5)/12)
Avg =AVERAGE(((B2:B5)+(C2:C5)/12))
Does that help?
--
Regards,
Ron
"Tammi" wrote:
I am trying to find the lowest, highest, and average age based on a large
list. The ages are in terms of years and months, and do not rely on
birthdates.
A B
Years Months
1 2 10
2 5 6
3 4 8
4 2 9
Is this possible??
Thanks
|