Hi,
I am looking at counting how many product codes are in a column by a set date, and then counting the weight of those products.
I have a working formula here that will count product by date: =SUMPRODUCT((B8:B24=B3)*(D8:D24=B5)) Total= 6 (See attached image for spreadsheet)
EXCEL.jpg
I now need to sum the total weight of those selected 6 cartons (by above formula).
Can anyone help me with this formula?
Thanks
Bookmarks