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

Subject: | Use of sumproduct() in EXCEL |

Posted by: | ÎÎ¹ÎºÎ¿Ï‚ |

Date: | Thu, 25 Jan 2007 |

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 Harlan Grove on 25 Jan 2007
- Re: Use of sumproduct() in EXCEL posted by Bob Phillips on Thu, 25 Jan 2007