2012 Archives by date, by thread · List index

# Re: [libreoffice-users] Multiply values BEFORE summing

```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: 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
```