Saturday, September 23, 2023
Home Formulas & Functions Aggregation Functions

# Aggregation Functions

These posts discuss functions that return sums, counts, standard deviations, maximum values, and other summary information.

### How to Use SUMIFS with Criteria Lists, Summarizing Sales

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

### How to Smooth Data by Using the TREND Function

Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...

### Using the Hidden Power of Excel’s FILTER Function

When you take the time to explore a new worksheet function, it's amazing what you can discover! And I won't tell you about the really...

### How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...

### Excel’s SUMIFS or SUMPRODUCT…Which is faster?

Today, I learned about an Excel reporting need that looks something like this: There’ll be about 150,000 rows of data maintained in an Excel database. ...

### How to Create Summarized Financial Statements with SUMIFS Criteria Lists

In How to Use SUMIFS with Criteria Lists, Summarizing Sales, I explained how to use the SUMPRODUCT function with SUMIFS to return the sum of...

### How to Smooth Monthly Trends with Centered Moving Averages

I recently read an article in the Wall Street Journal about the expected increase of electric vehicles in the US. That made me wonder...

### How to Use SUMPRODUCT in Excel 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 told him...

### How Fast Is Too Fast?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

### How to Smooth Data by Using the TREND Function

Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...

### Consumer Sentiment Suggests a 2022 Recession

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...