SUMPRODUCT for shipping weight, multiple array
Hi I am new to the forum, have a question here if anyone can help?
I have products with different sizes and different weights, I want to have a cell formula to calculate the total weight of all products from one order.
I used sumproduct function but don't how to handle the array includes columns and rows, any suggestions are appreciated.
what do you mean by that?: =SUMPRODUCT((Orders[Retailer]=[@Retailer])*Orders[[S]:[L]]*Product[[S]:[L]])
how should [S]:[L] be multiplied?
Thank you for your reply.
I just worked that out, need to index the Products array.
This proposal employs three helper columns (K:M) which may be moved and/or hidden for aesthetic purposes.
The helper columns are populated using: =SUMPRODUCT((Product[[SKU]:[SKU]]=$G3)*(Product[S]))*H3
The weight column is populated using: =SUMPRODUCT((Orders[Retailer]=O3)*(K$3:M$11))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks