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

  Рет қаралды 34,316

The Excel Explorer

The Excel Explorer

Күн бұрын

**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.
Sum Between Dates.xlsx - bit.ly/2M0wBYx
**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?

Пікірлер: 6
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
EOMONTH Function in Excel: How to + 8 Examples | Excel Off The Grid
12:21
Excel Off The Grid
Рет қаралды 7 М.
Sumif Between Two Dates: You've Been Doing It Wrong!
4:52
Productivity Land
Рет қаралды 2,2 М.
How to Use SUMIFS, COUNTIFS and AVERAGEIFS in Excel (Multiple Criteria)
14:04