SUMIFS between two dates

Premium

In F3, total the amounts of the orders dated from F1 to F2, both days included. Give SUMIFS the date column twice: ">="&F1 and "<="&F2.

F3
ABCDEFG
1Order date Customer Amount From Mar 1, 2024
2Feb 27, 2024 Northwind 640 To Mar 31, 2024
3Mar 1, 2024 Oakline 310 Total
4Mar 8, 2024 Northwind 820
5Mar 15, 2024 Pinecrest 150
6Mar 22, 2024 Oakline 470
7Mar 31, 2024 Brightside 290
8Apr 2, 2024 Northwind 560
9Apr 9, 2024 Pinecrest 380
10

Premium lesson

Unlock SUMIFS and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:COUNTIFSVLOOKUP

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?