Formula to find nth Value based on multiple criteria with duplicates

Hi! I am trying to create a formula that will group quantities of a particular SKU by their expiration dates. However, the data has a lot of duplicate expiration dates.

I've tried multiple variations of FILTER, SMALL, etc and can't figure out how to return the next value based on criteria.

Please take a look at the below image to see the type of data, as well as my desired results. I've included the file in the attachments as well.

Screenshot 2024-03-22 at 2.15.06 PM.png

Thank you so much for your help, I've spent hours on this!

Formulas.

Formula:

Please Login or Register  to view this content.

hi there, my proposal solution:

Please Login or Register  to view this content.

I hope it results useful.

EXP REPORT (SOLUTION).xlsx

Thank you so much! DJunqueira, quick question.. I am trying to use this in Google sheets and it's not letting me use the "$F$8#" but I tried $F$8:$F$10 and it seemed to have worked. Do you know if there is any potential issue with this edit?