I need a formula to sum qty of product in an area if multiple criteria are met. Then I need a formula which divides that result by the total qty of that product in all areas.
In the attachment:
A1:D10 has multiple product qty's, with unique descriptions, in multiple areas.
G1:K8 I'm trying to create a summarized table that would show qty of unique product in an area and the % of that unique qty in an area against it's total unique qty in all areas.
Bookmarks