Excel formula to take data only for Running periods -

I have two dates in the excel file containing the inventory: the start date and the end date

I want to be able to calculate the amounts which do not have an end date set.

With a unique list of vendors in the column G is starting in G2 and its first volume Validate in E2, please try:

  = SUMIFS (E: E, B: B, G2, D: D, "")  < / Pre> 
 has been copied down to suit.