SUMIF Help

[halfpint123]

Hi

I have a spreadheet with 2 tabs.

Tab 1 - Analysis

This tab has 3 columns

Unit Number: unique item number. One row per item on this tab.
Expiry Days Allowed: the number of days the above item is allowed to be kept in the warehouse
Total Quantity: this is the number of items left in the warehouse that are within or equal to the expiry date

Tab 2 - Stock

In the warehouse units are kept within batches.

This tab has for columns

Batch Number: unique batch number. One row per batch on this tab.
Unit Number: Unit number as per tab 1
Quantity: The number of units held within this batch.
Days To Expire: the days left for expiry on the batch.

What I would be very grateful for is a help with a formula to work out total quantity on tab 1. This would be for the item number, adding the quantity for batches that are within or equal to their expiry date.

I just can't work out anything.

Thanks Example.xlsx

[Sam Capricci]

is this what you are looking for in tab 1 cell C1? =SUMIF(Stock!A:A,Analysis!A2,Stock!C:C)

[Fotis1991]

Try

=SUMPRODUCT((Stock!$B$2:$B$13=Analysis!A2)*(Stock!$D$2:$D$13<=B2)*(Stock!$C$2:$C$13))