- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Re: Use of sumproduct() in EXCEL

Subject: | Re: Use of sumproduct() in EXCEL |

Posted by: | Bob Phillips (bob.N…@xxxx.com) |

Date: | Thu, 25 Jan 2007 |

=SUMPRODUCT((A1:A100*B1:B100)+(C1:C100*D1:D100))

--

---

HTH

Bob

(change the xxxx to gmail if mailing direct)

"?????" <@discussions.microsoft.com> wrote in message

news:91B50EDB-E6EB-421B-A97B-1F0FE7607C…@microsoft.com...

> Hi.

> Does anyone know if I can use the sumproduct() formula in parallel

> columns?

> For example lets say that I have n columns A1:A100 =1:100,

> B1:B100=10:1000,C1:C100=101:200,D1:D100=1010:2000,.,etc.

> I would like to calculate the sum A*B + C*D + ...+ Xn*Xn+1, using

> sumproduct() formula and without say sumproduct()1 + sumproduct()2+...+

> sumproduct()n.

> The sumproduct formula must be used only once.

> Any idea

> Thank you.

- Re: Use of sumproduct() in EXCEL posted by ÎÎ¹ÎºÎ¿Ï‚ on Thu, 25 Jan 2007

Use of sumproduct() in EXCEL posted by ÎÎ¹ÎºÎ¿Ï‚ on Thu, 25 Jan 2007