Thanks Max - I've got it working now and have learnt a bit more today.
Thanks for the explanation of the -- and the f2/f9 - I knew this calcd a
cell but hadn't throught of doing it to see the array.

I also managed to get something similar working using a sumproduct
(with no arrays) =SUMPRODUCT((A2:C2<=D1)*A4:C4) - with A4-C4 being the
range I wanted to multiply it by.


Thanks Again

Ruth
Cambridge UK


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=383429