Sunday, October 25, 2020
How to Use SUMPRODUCT to Find the Last Item in an Excel List

How to Use SUMPRODUCT to Find the Last Item in an Excel List

Suppose you have a Sequential List of items, as in the second table in the figure below. And suppose you want to show the...

How to Use SUMPRODUCT to Create Two-Dimensional Lookups in Excel Formulas

A friend recently asked, "In this table, how can I return the date where the lowest value occurs?" More generally, however, he was asking how to...
Array formulas may be Excel's most-powerful feature for summarizing data. But they're also a little-used feature of Excel. Here's how to use their power.

How to Summarize Spreadsheet Data with Excel’s Array Formulas

Subtotals can reveal very useful management information. For example, managers might be interested to learn that sales increased by 10% last month. But they would...
Excel's SUMPRODUCT function offers much of the power of Excel array formulas, but without special treatment.

Use Excel’s SUMPRODUCT to Summarize Worksheet Data

After I posted  The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis, a reader asked why I hadn't discussed the SUMPRODUCT function. I...

Latest Articles

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...