Hi,
I have some data that I need to reference from a different sheet while its closed. I know I need to use sumproduct instead of sumifs but I can't seem to get it to work. I need to total the number of lbs for each day.
"Raw Data"
<tbody>
A
B
Date
LBS
05/01/18
10
05/01/18
44...