Thanks Claus, sorted the problem out 100%. You saved me a lot of frustration. Just don't quite understand why you have to use Ctrl+Shift+Enter for array formulas?
Quote:
Originally Posted by Claus Busch
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
|