Thread
:
Sumproduct + Array Function?
View Single Post
#
4
Darren Hill
Posts: n/a
On Thu, 08 Sep 2005 00:14:52 +0100, Harlan Grove wrote:
Use the array formula
=SUM(B2:B10*MMULT(--(ROW(C3:C11)<=TRANSPOSE(ROW(C3:C11))),C3:C11))
Thank you very much :)
------------------
Darren
Reply With Quote