The SUMIFS function returns a sum for nearly any number of single criteria. But with SUMPFODUCT you can return the sum for many criteria listed in a Criteria List.

How to Use SUMIFS with Criteria Lists, Summarizing Sales

Accounting & Finance Charley Kyd - 0
With one exception, SUMIFS is a very powerful function. And it's very fast. To understand the one exception, suppose you have a table of sales...
Pivot Tables aren't merely a way to interact with your data. You also can use them as a rich source of data for standard reports and analyses. And you don't need to limit formulas to GETPIVOTDATA; you also can use SUMIFS, SUMPRODUCT, and all other Excel functions with pivots. Here's how.

How to Set Up a Pivot Table as an Excel-Friendly Database

Business & Economics Charley Kyd - 0
You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs). In...
Beginning in Excel 2016 in Office 365, your formulas can set gaps in your line and scatter charts. Here are two ways to use the feature in your reports.

Two Business Uses for Excel’s New Chart Feature

Analytical Methods Charley Kyd - 0
For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...
When you include recessions and economic downturns in your charts, you can show your company's performance in a much better context. Here's how to set up your Excel charts to display those recessions and downturns.

How to Show Recessions in Excel Charts

Analytical Methods Charley Kyd - 0
I showed you the following figures in Chart Your Rate of Change to Reveal Hidden Business Performance. The line in the first chart below shows Apple's...
By charting the annual Rate Of Change (ROC) of key measures, you can uncover significant information about your time-series data. And by using the right recession measure, you can put that information into better context.

Chart Your Rate of Change to Reveal Hidden Business Performance

Analytical Methods Charley Kyd - 0
What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years? I see three things. First, their...
An Excel-Friendly Database is defined as an organized collection of data from which worksheet formulas can return values. Here are five Excel-friendly databases.

Introducing Excel-Friendly Databases

Business & Economics Charley Kyd - 0
The most productive way to flow data to your Excel reports and analyses is to use Excel formulas to flow data from an Excel-Friendly...
Excel Tables offer the ability to filter on two criteria in one column. Here one way to search for many criteria in a Table.

How to Add Advanced Filter Capabilities to Excel Tables

Excel Tables Charley Kyd - 0
One useful feature of Excel Tables is the ability to filter any number of columns. The filter control for each column allows us to...
Excel offers two powerful worksheet functions that can return just the data you need from Excel Tables.

The Excel-Friendly Database Strategy

Business & Economics Charley Kyd - 0
Here's the key to slashing both your Excel errors and the time it takes you to create and update your Excel reports... Get your plumbing...
Which is faster: VLOOKUP? Or INDEX-MATCH? Here are the test results.

Excel’s Fastest Lookup Methods: The Tested Results

Business & Economics Charley Kyd - 0
This article presents the results of my tests to find Excel’s fastest lookup method. I discussed the report workbook in A Volatile Workbook to Test Calculation...
You need a volatile workbook to test Excel calculation speeds. Here's how I set one up to test lookup formulas.

A Volatile Workbook to Test Calculation Times for Excel Lookup Methods

Business & Economics Charley Kyd - 0
In Use Excel VBA to Test Report Calculation Times I described a macro that finds the total time necessary to calculate Excel for a specified number...
1...19202122Page 20 of 22