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?
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
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