# Conditional Average Formula

This is a discussion on Conditional Average Formula within the Excel Questions forums, part of the Question Forums category; Good morning, everybody, Does anyone know how to use Excel conditional average function or Excel macro to get the following ...

1. ## Conditional Average Formula

Good morning, everybody,
Does anyone know how to use Excel conditional average function or Excel macro to get the following Total Average, Latest 3 Years’ Average and Latest 2 Year’s Average?
I would appreciate any solutions.
Dennis

1996 88
1997 21 122
1998 66 44 156
1999 56 100 67 190
2000 45 79 134 90 224
2001 79 102 168 113
2002 113 125 202
2003 147 148
2004 181

Total Average 113 102 134 67 156
Latest 3 Yr's Average 147 125 168 90 190
Latest 2 Yr's Average 164 136.5 185 101.5 207

2. ## Re: Conditional Average Formula

Good morning to you too!

******** ******************** ************************************************************************>
 Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows Windows 2000
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B11C11D11E11F11B12C12D12E12F12B13C13D13E13F13 =

A
B
C
D
E
F
1
1996****88
2
1997***21122
3
1998**6644156
4
1999*5610067190
5
2000457913490224
6
200179102168113*
7
2002113125202**
8
2003147148***
9
2004181****
10
******
11
Total*Average11310213467156
12
Latest*3Yr's*Average14712516890190
13
Latest*2Yr's*Average164136.5185101.5207
 Sheet6 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.