Count Product codes by date and sum weight

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

Welcome to the forum.
you can include the column to get the sum

=SUMPRODUCT((C8:C24)*(B8:B24=B3)*(D8:D24=B5))

Hi Matt,

It would help next time if you post a worksheet instead of a picture. I can't copy and paste a picture.

Since you are using 2007

Total >> =COUNTIFS($B$8:$B$20,$B$3,$D$8:$D$20,$B$5)
Weight >> =SUMIFS($C$8:$C$20,$B$8:$B$20,$B$3,$D$8:$D$20,$B$5)