Excel Sum for a Date Range
February 18, 2020
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
To calculate a total, based on multiple criteria, you can use the SUMIFS function. For example, you could get a total for all Pencil sales, in the West region, with this formula.
You can use operators, such as ">", "<", and wildcards, like "*", in SUMIFS criteria too. For example, put a start date in cell G3 and an end date in G4. Then, use this formula to sum all the West region Pencil sales in that date range.
=SUMIFS(D2:D10,B2:B10,F2, C2:C10,G2, A2:A10,">=" & G3, A2:A10,"<=" & G4)
Go to my Contextures site to see more ways to sum with criteria, and download the sample file.
Here's what's new on my Contextures site and blogs.
Pivot Table Tool: If you use pivot tables, download the latest version of my free Excel add-in, Pivot Power Free (PPF).
Here are a few Excel-related articles that you might find useful or interesting.
Reminder: Don't miss Mynda Treacy's one-hour free webinar that shows how to make impressive interactive dashboards, using built-in Excel features. Mynda offers a full Excel Dashboard Course or Power BI Course too - and registration closes on Thursday, Feb. 18th.
New Features: The Register looks at a couple of new features coming to Excel -- Office Scripts and the XLOOKUP function. (Level-All)
Superhero: On the latest episode of their Australian accounting podcast, "From the Trenches", David Boyar and Paul Meissner explain why Excel is your superhero (at 4:15 mark).. Like the rest of us, they're excited about XLOOKUP. (Level-All)
Excel Humour: See what people said about Excel recently. As you know, a 3-D chart is never the answer
Do you remember those old commercials that asked, "Where's the Beef?" Well, I found it last week, at the grocery store, stacked in front of the butcher counter! And yes, we have a few "beefs" with Excel, but overall, it's "Genuinely Better" than other spreadsheets.
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200218ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: February 17, 2020 10:41 AM