Sum product

[sudhakarmn]

Dear All,

Good day, can anyone help me out with the formula of sum-product. the example is written below,


=(P$440*P445)+(P$456*P461)+(P$472*P477)+(P$488*P493)+(P$504*P509)+(P$520*P525)+(P$536*P541)+(P$552*P557)+(P$568*P573)+(P$584*P589)+(P$600*P605)+(P$616*P621)+(P$632*P637)+(P$648*P653)+(P$664*P669)+(P$680*P685)+(P$696*P701)+(P$712*P717)+(P$728*P733)+(P$744*P749)+(P$760*P765)+(P$776*P781)+(P$792*P797)+(P$808*P813)+(P$824*P829)

Waiting for you valuable input.

Regards

Sudhakar

[daddylonglegs]

This formula should give you the same result

=SUMPRODUCT(P$440:P$824,P445:P829,(MOD(ROW(P$440:P$824)-ROW(P$440),16)=0)+0)

[sudhakarmn]

Thanks for your prompt reply daddylonglegs's, works great.