Subtotal Function

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

### How to Sum Only Positive Numbers in Excel (4 Simple Ways)

We can easily Sum a range of Excel datasheets. But, quite frequently we need to add the cell values following a condition. This article will show you ...

### How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)

In this article, we’ll illustrate how to use the COUNTIF function with the SUBTOTAL function in Excel to count filtered data using two convenience ...

### How to Use SUBTOTAL Function in Excel (3 Suitable Examples)

SUBTOTAL is one of the default functions of Microsoft Excel. This function provides the opportunity to perform a group of Excel function operations. ...

### How to Calculate Average in Excel (Including All Criteria)

In Microsoft Excel, there are several ways to calculate an average of a range of data. In this article, we’ve tried to include all possible criteria ...

### How to Create and Use ColorFunction in Excel (With Easy Steps)

In Excel, there is no function to make calculations based on the color of the cells. But by using Microsoft Visual Basic for Applications (VBA) it is ...

### How to Sum Colored Cells in Excel (4 Ways)

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. Yet multiple ways can manage to sum up the cells based on ...

### How to Sum Colored Cells in Excel Without VBA (5 Ways)

Excel is a great tool for visualizing and analyzing data. While working with Excel sometimes it becomes necessary to sum the values of the colored ...

### Automatically Number Rows in Excel (10 Easy Ways)

Looking for ways to automatically number rows in Excel? Do not worry, we are here for you. In this article, we will describe 10 easy ways to do the ...

### How to Sum Rows in Excel (9 Easy Methods)

In Microsoft Excel, the Sum is one of the most common operations we use. There are different techniques to sum up values in multiple rows in excel. ...

### How to Sum a Column in Excel (10 Easy Methods)

Excel is an immensely powerful application, with a lot of features and formulas for mathematical operations. You can do summation, subtraction, ...

### How to Add the Sum of a Column in Excel (7 Easy Ways)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

### How to Do Automatic Numbering in Excel (12 Simple Ways)

While dealing with a large dataset, you may need to assign automatic numbers to your cells. However, manually applying the number is a tedious task. ...

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

### How to Sum Multiple Rows Using INDEX MATCH Formula

Microsoft Excel is a powerful program where we can perform numerous operations on our datasets using its tools and features. In many instances, you ... Advanced Excel Exercises with Solutions PDF  