# Contextures News 20200218

Excel Sum for a Date Range

February 18, 2020

Pivot table tool, total for a date range, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

### Sum for Date Range

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.

=SUMIFS(D2:D10,B2:B10,F2,C2:C10,G2)

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.

### On Contextures

Here's what's new on my Contextures site and blogs.

### Excel Articles

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

Also see: My Excel Products || Previous Issues

### Genuinely Better

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.