Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria

Discover how to sum values between two dates, for a month, and with multiple criteria. You'll also learn how to sum values within a month. For example, your data set contains dates and you'd like to create a monthly report where you show the total value for the month, you can use the SUMIFS function together with the EOMONTH (end of the month Excel formula).

Key Focus:
▪️ Sum Between Dates: Learn to use SUMIFS for specific date ranges.
▪️ Monthly Totals: Find out how to sum revenue for entire months.
▪️ Advanced Criteria: Add extra conditions like app categories for detailed analysis.

👨‍💻 Inside the Tutorial:
▪️ SUMIFS Formula: Easy-to-follow guide on arguments like sum range and criteria.
▪️ Date Ranges: Tricks to select the right dates using functions and formatting.
▪️ Helper Cells: Use EOMONTH and other formulas for precise calculations.
▪️ Extra Tips: Formatting and checking results to ensure accuracy.

Use the Excel SUMIFS formula to sum values between two dates.
Here you'll need to use the greater than & less than operators inside the SUMIFS formula.

Last, you'll learn how to add more criteria to your sum range. For example, you'd like to sum values between two dates and also account for one or more additional criteria.
Happy learning!

★★ Links to related videos: ★★

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[jvclfsm]

I CANT EVEN THANK YOU ENOUGH!! I had been struggling since March 2017 (and searching countless Excel videos) and asking several Excel experts, and nobody could start to help.. and finally I found this video! It not only fixed my issue and saved me hours of time each year, BUT when I go to save 2022's workbook as 2023, all I'll need to do is change 2 digits and the ENTIRE 2023 workbook will update!! Thank you from the bottom of my heart! ❤️ MUAH!!

[franciscoveras]

Nothing more exciting than when you have been working for an entire day trying to figurate out how to sum values between two dates and just when you decide to commence to work with a VBA code, you see a video from Leila with the very exact thing that you are looking. THANKS, you save me again

[ziggymasternak]

I spent two days browsing through excel support sites, forums, LinkedIn training and even Excel inbuilt "help with this function" link which is actually a paid service and not necessarily will do what you want (you can't open the file until you pay :) ), until I came across your video and you made everything clear, resolved my worksheet problem and I have learned a lot at the same time. Thank you.

[GodWillIncreaseNitzborn]

This formula to sumif between dates helped me big time to create countifs formula... 😍👌👍🏽 Praise be to God!

[kyilin]

Sharing excel videos about sum between date and time on YouTube is rare to see. But you are such an amazing.
Thank you so much.

[ajwatypingphotocopying]

I MANUALLY FINISHED MY PREVIOUS TASK BUT THEN IN NEXT TRY AND TASK I OVER CAME MY DIFFICULTY. THANK YOU GORGEOUS LADY, SO MUCH LOVE

[jacquesconradie]

Dear ms. Leila, we appreciate your clear logical explanations and your sweet friendly manner.

[rickyroko]

I had been struggling for 1 hours to do this, trying to read blogs and sloppy guides, before i found this. You were brillant! Now IT IS easy!

[martinmamone]

After googling for a formula that didn't work, I decided to try you tube. Your video worked like a charm. Excellent job, clear, concise and most importantly, it worked. Kudos

[kileesmommy]

You are amazing! I watched a couple of your videos and was able to solve a problem I was having doing a formula. I had been watching other videos and trying to figure it out for a week! You're the best!!!

[oliverbuckley]

SUMIFS is a great function, but I never realised you could use > and <. Brilliant! Well done and thanks.

[OmarFeliciano]

I cannot get enough of Excel formulas and Functions, honestly I'm obsessed to the point that I create whatever it's needed to have an excuse to work with Excel. Same when I'm debugging software to reverse engineer it. It calms me down and relaxes. That and the way you explain/show/teach its just the icing on the cake..

[rizalfatoni]

Sumifs from date A to date B is really useful for tracking data progress. Thanks a lot Leila.

[DT-vchd]

Thank you! I failed several times on my own to create a function with multiple criteria (Date Start, Date End, Category), and this tutorial gave me knowledge to accomplish that!

[federicococchis]

very helpfull, Thank you very much for this clear explanation. My will to live has increased dramatically after solving the problem that was passed down in my generation for years. Thank you again

[TraderCOP]

4 years later, this video is still valuable.

[shabirvadalia]

This function is phenomenal, an instrument that has enabled me to become efficient and effective. Well done.

[teoxengineer]

Dear Leila,
Another way to sum values between days is that
index():index() formula is very useful and handy one I have ever learned from you
Thanks again

[ibrahimwork]

YOUR SUCH A LIFE SAVER. The best EXCEL tutor out there on youtube and the way you explain and demonstrate is so amazing. SIMPLE, RELEVANT AND ALWAYS TO THE POINT. A 1000 likes for all the great content and the efforts you make.

[asthegooseflies]

Terrific video - many thanks. Solved a lot of frustration! It is great that you show common mistakes with the formula build, to help struggling Excel users like me!