I have an excel sheet with a simple sum fuction, but I want that fuction to work for all the products on a specific date. E.x Lets say that on 14/12/2021 I received 20 products each one with different size. I want the add fuction to add all the sizes together on that date and create a number but when the new shipment comes on e.x 25/01/2022 I need the add fuction to add the products after that date and ignore the products and their sizes before that date. Is something like that possible ? Thank you in advance for the enlightening

Sample:

CodePudding user response：

I assume this is what you want:

=SUMIF(A2:A5,MAX(A2:A5),C2:C5)