Contextures

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)

sumifs 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.

sumifs date range

On Contextures

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).

Pivot Power Free Update

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.

weekly photo

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.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

contextures newsletter info

 

Related Links

How to sum with criteria

Pivot Power Free

Pivot Power Premium

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: February 17, 2020 10:41 AM