Hi,

Am Fri, 24 Oct 2014 16:07:54 +0100 schrieb JWEV:

=AVERAGE(IF(($A$1:$A$15$C1)*($A$1:$A$15<=$D1),$B$ 1:$B$15))

this formula is an array formula to insert with CTRL+Shift+Enter
Then you get the correct result


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional