Help Power Excelman!

[rmir1341]

DEAR EXCELMAN,


I want multiple and sum below array,for example:

A B
1 10
2 20
... ...

= (A1:A20)*(B1:B20)*(B1+B2)/2 HOW we can added (cell B1 TO B20) i
the form *(B1+B2)/2 AND then (B2+B3)/2 ......

Thanks and best regard


rmir134

 

[Frank Kabel]

Hi
not fully tested but try
=SUMPRODUCT(A1:A20,B1:B20,(B1:B20+B2:B21)/2)