Currently I have a data sheet:
5 Columns - Week/Plant/Type/Capacity/Pounds Shipped.
I currently have a sumproduct formula to add up all Pounds shipped by a certain week, certain plant, certain type and then divide by the capacity by the same certain week, certain plant, and certain type to get a %.
I am just now digging into index(match) formulas, but do not know if this is the way to go?
Here is my current formula:
=SUMPRODUCT((Data!J$2:J$64997=Danville!A3)*(Data!B$2:B$64997=Danville!B$1)*(Data!E$2:E$64997=Danville!C$1)*(Data!H$2:H$64997))/SUMPRODUCT((Data!J$2:J$64997=Danville!A3)*(Data!B$2:B$64997=Danville!B$1)*(Data!E$2:E$64997=Danville!C$1)*(Data!F$2:F$64997))*100
Any suggestions?
5 Columns - Week/Plant/Type/Capacity/Pounds Shipped.
I currently have a sumproduct formula to add up all Pounds shipped by a certain week, certain plant, certain type and then divide by the capacity by the same certain week, certain plant, and certain type to get a %.
I am just now digging into index(match) formulas, but do not know if this is the way to go?
Here is my current formula:
=SUMPRODUCT((Data!J$2:J$64997=Danville!A3)*(Data!B$2:B$64997=Danville!B$1)*(Data!E$2:E$64997=Danville!C$1)*(Data!H$2:H$64997))/SUMPRODUCT((Data!J$2:J$64997=Danville!A3)*(Data!B$2:B$64997=Danville!B$1)*(Data!E$2:E$64997=Danville!C$1)*(Data!F$2:F$64997))*100
Any suggestions?