luis_marques
Member
Hi,
I have a sheet where each row is an order.
Each order may have since 1 product until n products.
The export file of this data order present a pattern of data that repeats every each 14 columns for each product
Those 14 columns are data of just 1 product of 1 order.
I need to multiply 2 columns of each product and then sum with another multiplication of the next 2 columns of the further product.
In order to facilitate comprehension, i uploaded an example sheet. I put just one row that represent one order. There is a set of 14 columns that repeat in this row. I put just 4 set of 14 columns. Remember that each 14 columns represent one product of this order (row). I need to multiply the 4 th column with 12 th column.
If there is just one product, that is simple like the ordinary formula i put in the outline in the file. But if there are several products in the order, i need to multiply the 4 th with 12 th column for each product and after sum all. The number of products data (each 14 columns in the row) are variable for each order (row)
I need a formula to recognize such pattern and make this calculation.
I hope you can help me. Please dont hesitate to ask if you find explanation confusing.
Best Regards
I have a sheet where each row is an order.
Each order may have since 1 product until n products.
The export file of this data order present a pattern of data that repeats every each 14 columns for each product
Those 14 columns are data of just 1 product of 1 order.
I need to multiply 2 columns of each product and then sum with another multiplication of the next 2 columns of the further product.
In order to facilitate comprehension, i uploaded an example sheet. I put just one row that represent one order. There is a set of 14 columns that repeat in this row. I put just 4 set of 14 columns. Remember that each 14 columns represent one product of this order (row). I need to multiply the 4 th column with 12 th column.
If there is just one product, that is simple like the ordinary formula i put in the outline in the file. But if there are several products in the order, i need to multiply the 4 th with 12 th column for each product and after sum all. The number of products data (each 14 columns in the row) are variable for each order (row)
I need a formula to recognize such pattern and make this calculation.
I hope you can help me. Please dont hesitate to ask if you find explanation confusing.
Best Regards
Attachments

9.6 KB Views: 14