I have some data that I need to find out what the total for the lbs used for each day equates to? Thanks in advance.
<colgroup><col span="8"></colgroup><tbody>
</tbody>
Sincerely,
Big Ry
4/22/2018 | 4/23/2018 | 4/24/2018 | 4/25/2018 | 4/26/2018 | 4/27/2018 | 4/28/2018 | |
Lbs used | |||||||
Cases | 5,000 | 9,000 | 7,000 | 8,750 | 15,472 | ||
Raw Data Table | Vlook up table | ||||||
Date | Product | lbs | Product | Lbs / case | |||
4/22/2018 | abc | 1,587 | abc | 5 | |||
4/22/2018 | xyz | 1,589 | XYZ | 7 | |||
4/22/2018 | abc | 5,484 | |||||
4/23/2018 | abc | 4,120 | |||||
4/23/2018 | xyz | 2,358 | |||||
4/23/2018 | abc | 5,875 | |||||
4/24/2018 | abc | 5,486 | |||||
4/24/2018 | xyz | 9,878 | |||||
4/25/2018 | abc | 9,852 | |||||
4/25/2018 | abc | 3,547 | |||||
4/26/2018 | abc | 3,487 | |||||
4/26/2018 | xyz | 8,575 |
<colgroup><col span="8"></colgroup><tbody>
</tbody>
Sincerely,
Big Ry