Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

AGGREGATE Function

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

How to AutoFill Numbers in Excel with Filter (2 Methods)

We often need to work with huge datasets in Excel. AutoFilling numbers with Filter can make our task much easier. So, we should know how to AutoFill ...

Excel Formulas to Fill Down Sequence Numbers Skip Hidden Rows

Sometimes we need to hide some unnecessary rows in Excel to present the information. There we frequently face a problem filling down the sequence ...

How to Auto Number or Renumber after Filter in Excel (7 Easy Ways)

We often use Filters in Excel to sort data. Sometimes we may need to arrange data from smaller to bigger or vice versa. It is tiresome to arrange ...

[Fixed!] AVERAGE Formula Not Working in Excel (6 Solutions)

You may face some problems in some cases while using the AVERAGE formula in Excel. But no worries, there are a lot of ways to solve it. This article ...

How to Sum Entire Column in Excel (9 Easy Ways)

Summing up is an important aspect of any datasheet in Excel. Sometimes, we need to sum the entire column in excel for effective data analysis. There ...

51 Mostly Used Math and Trig Functions in Excel

The Math & Trig functions in Excel are very common in many mathematical calculations like- basic arithmetic, conditional sum & product, ...

How to Sum Only Visible Cells in Excel (4 Quick Ways)

There are a few ways to Sum Only Visible Cells in Excel. Today we will go through 4 quick ways to Sum Only Visible Cells. Frequently, we need to hide ...

44 Mathematical Functions in Excel (Download Free PDF)

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

How to Use AGGREGATE Function in Excel (13 Examples)

In Excel, the AGGREGATE function is used on different functions to get specific results. In this article, we will show you how to use the AGGREGATE ...

How to SUM Ignore N/A in Excel (7 Simple Ways)

In a large dataset, there is a possibility of having some null or blank cells. The SUM function doesn’t work with #N/A values but there are several ...

ExcelDemy
Logo