[libreoffice-users] Multiply values BEFORE summing

Hi,

I have about 2453 records for which I require to sum numerous columns 
ie. A * H, A* I , A*J ....

The following equation will sum the values of each column 
[=SUM($H$2:$H$2453)].  Is there a way I can multiply the summation 
column by the corresponding  column A value for each record?  What I am 
trying to avoid is creating another sheet which multiplies the values 
before summing.

In pseudo code what I want is  =SUM($A$2*$H$2:$A$2453*$H$2453) which 
unfortunately does not work.

A          H           I             J            K L           M
2.59    26.64    27.31    27.98    28.65    29.32    29.99
2.29    18.26    18.81    19.36    19.91    20.46    21.01

Windows XP
LibreOffice 3.4.4

Thanks,

Vytas

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted