Hi Vytas,
Vytas schrieb:
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
You need the function SUMPRODUCT.
Kind regards
Regina
--
For unsubscribe instructions e-mail to: users+h...@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