Hi,
nice to be part of the forum.
I am finding it difficult to find a solution to the following and would welcome any assistance.
I have created a table which expands as new data is added, each column is a unique item which has a weight. I need to obtain the gross weight over all the columns, this will vary as the table expands.
Idealy the sumproduct function would work by multiplying the sum of each column by the weight of the item, but how can I create a formula which will create an array of the "sum" of each column then use this information as an array in the sumproduct function calulation then combine this with the weight array
I can get the result by creating a total on row 1, which sums each column the uses each total in the sumproduct function but I am interested if there is a more efficient way to achieve this answer.
Many thanks for looking.
Jek61
nice to be part of the forum.
I am finding it difficult to find a solution to the following and would welcome any assistance.
I have created a table which expands as new data is added, each column is a unique item which has a weight. I need to obtain the gross weight over all the columns, this will vary as the table expands.
Idealy the sumproduct function would work by multiplying the sum of each column by the weight of the item, but how can I create a formula which will create an array of the "sum" of each column then use this information as an array in the sumproduct function calulation then combine this with the weight array
I can get the result by creating a total on row 1, which sums each column the uses each total in the sumproduct function but I am interested if there is a more efficient way to achieve this answer.
Many thanks for looking.
Jek61