T
TitanG
I need a subtotal for 5 different products in a table
Column A will have 5 different colors (Blue, Green, Red, Black)
Column L has a price/rate
Column O - R have Quantity for each week (total of 4)
I need to have subtotals for each color for each week.
A L O P Q R
Blue 290 5 5 5 0
Green 190 5 5 5 5
Red 0 6 6 6 6
Green 10 10 10 10 10
Green 190 0 0 0 8
Black 20 5 5 5 5
From the example above I need subtotals for each color by week.
Any way to get this done with Sumproduct or sumif?
Greg
Column A will have 5 different colors (Blue, Green, Red, Black)
Column L has a price/rate
Column O - R have Quantity for each week (total of 4)
I need to have subtotals for each color for each week.
A L O P Q R
Blue 290 5 5 5 0
Green 190 5 5 5 5
Red 0 6 6 6 6
Green 10 10 10 10 10
Green 190 0 0 0 8
Black 20 5 5 5 5
From the example above I need subtotals for each color by week.
Any way to get this done with Sumproduct or sumif?
Greg