COUNT Function

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

### Formula to Remove Blank Rows in Excel (5 Examples)

Having blank rows in a Microsoft Excel worksheet is a common scenario. Most of them are unnecessary and they consume more spaces that increase the ...

### How to Calculate Moving Average in Excel (4 Examples)

The Moving Average is also known as the Rolling Average or Running Average in Excel. In this article, we will show you how to calculate the moving ...

### How to Use Excel FREQUENCY Function (6 Examples)

In Excel sheets, we store various types of data to get the insight of data. Sometimes to analyze any data you may need to calculate the frequency of ...

### Excel Data Validation Alphanumeric Only (Using Custom Formula)

Alphanumeric characters are a mix of alphabetical and numerical characters. There are 36 (A-Z and 0-9; case insensitive) or 62 (A-Z, a-z and 0-9; ...

### Excel Find Last Column With Data (4 Quick Ways)

In a large worksheet, finding the last column with data manually is time-consuming and not friendly. There are some functions by using which you can ...

### How to Find Last Cell with Value in Column in Excel

We use Excel for our official and business purposes. For those purposes, we use a big amount of data. Sometimes we need to find the last cell with ...

### How to Count If Cell Contains Number (Easiest 7 Ways)

If you are looking for some of the easiest ways to count if a cell contains number in Excel then you will find this article worthy of it. Sometimes ...

### Excel Count Number of Cells in Range (6 Easy Ways)

Counting the number of cells is a basic task in MS Excel. There are a lot of methods to do it. In this article, I’ll show 6 easy methods including ...

### How Excel Count Rows with Value (8 Ways)

There are several Microsoft Excel functions to count rows with a value in Excel. In this article, we are going to know about them with examples and ...

### COUNTIFS Unique Values in Excel (4 Easy Ways)

While working in Excel, we often have to sort out the unique values from a set of data. Sometimes we have to count the number of equal values in a ...

### How to Perform Partial Match of String in Excel (8 Easy Methods)

Whenever you are handling a wide range of data in your worksheet, partial matching or fuzzy matching is an effective way to find your match quickly. ...

### How to Use COUNT Function in Excel (6 Ideal Examples)

In general, the COUNT function in Excel helps us to count the number of cells containing numerical values within a given range. This is one of the ...

### Dynamic Range for Multiple Columns with Excel OFFSET

The article will show you how to use OFFSET Dynamic Range for multiple columns in Excel in effective ways. Dynamic range expands automatically when ...

### How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

We frequently add up a series of numbers, but in certain cases, we may need to sum the last 5 values in a row in Excel. In this article, I’ll discuss ...