Add up values based on 2 criteria of which one is a date

For various materials I have stock that has a certain expiration date. On a regular basis I need to check which have already expired, which will expire in 30 days, 60 days, etc.
On top of the date, I have a quality setting. See below for an example:

Now I like to see the total quantities of the materials that have an expiration date after or on 24-03-2025 but not later then 24-06-2025.
The formula I have entered does not come back with the expected result.

What am I doing wrong? Note I am not familiar with VBA.

Thanks in advance for looking at my problem. Looking forward to a possible solution.

Are you still using Excel 2010?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

You need to do the date comparisons separately. One with >= and the other with <=.

Please also update your forum profile.

C21, copied across and down:

PHP Code: 

=SUMIFS($B$2:$B$15,$D$2:$D$15,$A21,$C$2:$C$15,">"&B$20,$C$2:$C$15,"<="&C$20) 


You're welcome.




Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.