AGGREGATE Function

How to Ignore Blank Cells with Formulas in Excel Chart

Sometimes we have some blank cells in our dataset. When we plot them in an Excel chart, we can’t get the desired chart for these blank cells. In that ...

How to Drag Formula and Ignore Hidden Cells in Excel (2 Examples)

In some cases, we hide some of our rows and columns in Excel. But if we drag the formula from there, it will drag along with the hidden cells. If you ...

How to Keep Track of Invoices and Payments in Excel (3 Ideal Examples)

The article shows how to keep track of invoices and payments in excel. It’s pretty important for daily activities in a shop or market. Keeping track ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Sometimes it becomes a necessity for us to know the sum of some filtered cells. Though we can do it manually, Excel has some fantastic features to ...

How to Sum Selected Cells in Excel (4 Easy Methods)

If you are looking for some special tricks to sum selected cells in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

How to Use SUBTOTAL in Excel with Filters (With Quick Steps)

This article illustrates how to use the SUBTOTAL function in excel with filters. It is necessary when you need to apply some functions to a filtered ...

How to Add Up Columns in Excel (12 Methods)

In Microsoft Excel often we need to calculate the sum. For example, you have a dataset of sales and you need to summarize the total sales. For that, ...

Random Selection Based on Criteria in Excel (3 Cases)

Suppose we have a list of Name, Profession, Age, and Region. From the list, we want to get random Names but based on specific criteria. How should we ...

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

We can search match objects in Excel in different ways. There are different Excel functions, VBA codes are used to find the matching and return them. ...

How to Sum Columns in Excel When Filtered (7 Ways)

We use the filter function quite often because of its ability to churn up the most important insights of the data, which helps us immensely to make ...

How to Sum Columns in Excel Table (7 Methods)

Multiple numbers’ sum in Excel is a common task. I am confident that those who use Excel at least once used this feature. There are several ways to ...

How to Find Max Value in Range with Excel Formula (5 Easy Methods)

Sometimes we need to find the max value in a range using an excel formula. Luckily Microsoft Excel has several functions which we can use to ...

How to Use INDEX MATCH with Multiple Criteria for Date Range

Variables (such as commodity price, share, interest rate, etc.) subject to dates cause general people to panic, as their prices depend on dates. ...

How to Count Only Visible Cells in Excel (5 Tricks)

Sometimes, In excel, we need to count only visible cells. For instance, when you apply a Filter to excel data, certain rows become hidden. Besides, ...

Errors in Excel and Their Meaning (15 Different Errors)

Every now and then, we bump into errors in the Excel datasheet. Whenever we input something wrong in the formula or function, Excel lets us know that ...

ExcelDemy
Logo