Average calculations w/validation cell
Thanks for the advice Bernard.
A bit more information....
A B C
1 2005 20 15
2 2006 12 18
3 2007 22 45
4 2008 16 19
6 2 3 Validation cell. # of years
adds last 2, 3 yrs etc.
7 19* 27* always starting with 2008 CY
*16+22=38/2=19
*19+45+18=82/3=27
"Kgov" wrote:
I am using a validation cell to allow the user to pick if they want the
average to be calculated based on 2,3 or 4 years. I'm trying to develop a
formula so that after the # of years is picked it will then add 2, 3 or 4
other cells and give the appropriate averge...
|