Subtotal Function

Excel Cell Color: Add, Edit, Use & Remove

Sometimes we need to color our Excel cell to make the dataset unique, highlighted, beautiful, and easy to visualize. In this article, we will know ...

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

How to Number Rows Automatically in Excel (8 Methods)

Excel does not offer any features to number data while we enter/import them. It’s become difficult to understand any dataset without numbering. For ...

Editor choice How to Number Rows Automatically in Excel (8 Methods)

How to Count Rows with Text in Excel (Easiest 8 Ways)

If you are looking for some of the easiest ways to count rows with text in Excel, then you will find this article worthy of it. Sometimes different ...

How to Sum a Column in Excel (6 Methods)

Summing up is a usual thing which we need to do every now and then. But doing sum for a number of things may become a lengthy process. In this fast ...

All the Easy Ways to Add up (Sum) a column in Excel

Adding up all the cells in a column is one of the most used functions in Excel. In this article all the ways to add up a column in Excel will be ...

How to Number Rows in Excel (9 Simple Methods)

In Excel, you may come across repetitive tasks often. To number rows is one of these tasks which can be a time-consuming one. There are several ways ...

How to AutoFill Numbers in Excel (12 Ways)

There are several short and quick methods to autofill numbers in Microsoft Excel. In this article, you’ll learn how you can easily apply those useful ...

Automatic Numbering in Excel (9 Approaches)

Automatic numbering in Excel is a great way to save time and avoid boredom while you are dealing with a large database. Unlike other Excel Office ...

How to Copy a Formula in Excel with Changing Cell References

Do you need to copy formulas or functions in excel with or without changing cell references? There are lots of ideas and techniques to do it without ...

Excel Sum Last 5 Values in Row (Formula + VBA Code)

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 this article, I’ll discuss the ...

Index Match Sum Multiple Rows in Excel (3 Ways)

You may need to calculate the sum of multiple rows that match any criteria. Today we will show you how to apply INDEX - MATCH to sum multiple rows. ...

Excel Count Visible Rows (Formula and VBA Code)

To satisfy the demand of different circumstances you may need to count only the visible rows in Excel. Today we will show you how to count visible ...

How Do I Count Cells with Text in Excel (5 Methods)

You need to count how many cells contain text within your data set for many different operations. Today we will show you how to count cells with text ...

ExcelDemy
Logo