I am not sure if I understand sufficiently good what you try to achieve.
Could this be a solution
colum A ..... colum H.... create a new colum (a*h) and then sum up.
If this is not the solution it might be a good idea to express in normal mathematical formulas and
words what you want to achieve. This could make a translation into Calc formulas possible/easier.
On 2012-09-28 04:58, Vytas wrote:
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: [email protected]
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
