I have a cost matrix similar to this staged one:
The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose:
When only ONE Type of Material is requested, the following formula works:
=INDEX(COLLECT({Cost}, {Vendor}, [Preferred Vendor]@row, {Size}, Size@row, {Type}, [Type of Material]@row), 1)
I need to be able to calculate the SUMMED cost if a request is made for MULTIPLE materials in the same purchase order, indicated by the multi-select Type of Material column.