SUM Between Dates using SUMIFS [Multiple Criteria w/ SUMIFS]

preview_player
Показать описание
***SUM Between Dates***

In this video, we will be showing you how to use SUMIFS to calculate sales between two dates.

Watch this video and follow along to learn how the SUMIFS formula help you sum using date range as your criteria.

Aside from Date Range, SUMIFS can also be used with other multiple criteria. Try and learn to add another criteria with our Challenge of the Day (listed at the end of this video..)

If you are a professional looking to improve your skills on excel or be more efficient with your time, watch this video and learn the power of excel.

***CHALLENGE OF THE DAY***
After watching this video, try answering the challenge of the day and leave your answers on the comment section.

CHALLENGE #1
What is the total sales between January 15 to January 21?

CHALLENGE #2 (additional criteria)
What is the total sales between January 5 to January 11 that is greater than $3,000?
Рекомендации по теме
Комментарии
Автор

Thank you! I have been struggling with this for hours and your video made it super simple to understand 🙂

chrisfenton
Автор

Thank you, this tutorial is very, helpful.!.

Gospel-
Автор

For the challenge #1,
I get $33, 199

#2, I get $34, 760, though I'm not sure if that is correct!

douglasserwada
Автор

What i will be formule if your example have expense category, only sum between dates expense Groseries?

naturesage
Автор

My formula is the exact same format but returns zero

SteelLiox