Re: Use of sumproduct() in EXCEL

Giganews Newsgroups
Subject: Re: Use of sumproduct() in EXCEL
Posted by:  Harlan Grove (hrlng…
Date: 25 Jan 2007

=CE=9D=CE=B9=CE=BA=CE=BF=CF=82 <> wrote...
>Does anyone know if I can use the sumproduct() formula in parallel columns?
>For example lets say that I have n columns A1:A100 =3D1:100,
>I would like to calculate the sum A*B + C*D + =E2=80=A6..+ Xn*Xn+1, using
>sumproduct() formula and without say sumproduct()1 + sumproduct()2+=E2=80=
>The sumproduct formula must be used only once.

Why only one SUMPRODUCT call? Did you make a bet that this could be

If you don't use multiple SUMPRODUCT calls, follow Bob Phillips
approach, which DOES work as written. That is, as long as all cells in
A1:D100 contain numbers, the formulas




return the same result.


In response to

Use of sumproduct() in EXCEL posted by Νικος on Thu, 25 Jan 2007