Subtotal Function Archives - Page 3 of 4

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

Sep 19, 2023

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 Visible Cells in Excel (4 Quick Ways)

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

Sep 20, 2023

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 Sum Only Positive Numbers in Excel (4 Simple Ways)

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

Feb 12, 2023

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 COUNTIF with SUBTOTAL in Excel (2 Methods)

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

Sep 27, 2023

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 Use SUBTOTAL Function in Excel (3 Suitable Examples)

How to Calculate Average in Excel (Including All Criteria)

Mar 28, 2023

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 Calculate Average in Excel (Including All Criteria)

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

Jan 19, 2023

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 Create and Use ColorFunction in Excel (With Easy Steps)

How to Sum Colored Cells in Excel (4 Ways)

Sep 13, 2023

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 (4 Ways)

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

May 15, 2023

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

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

Automatically Number Rows in Excel (10 Easy Ways)

May 16, 2023

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

Automatically Number Rows in Excel (10 Easy Ways)

How to Sum Rows in Excel (9 Easy Methods)

Feb 16, 2023

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 Rows in Excel (9 Easy Methods)

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

May 8, 2023

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

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

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

May 9, 2023

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 Add the Sum of a Column in Excel (7 Easy Ways)

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

Sep 18, 2023

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 Do Automatic Numbering in Excel (12 Simple Ways)

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

Feb 16, 2023

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 Last 5 Values in a Row in Excel (5 Handy Approaches)

How to Sum Multiple Rows Using INDEX MATCH Formula

Feb 7, 2023

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