Subtotal Function Archives - Page 4 of 7

How to Sum Selected Cells in Excel (4 Easy Methods)

Feb 19, 2023

If you are looking for some special tricks to sum selected cells in Excel, you've come to the right place. In Microsoft Excel, there are numerous ...

How to Sum Selected Cells in Excel (4 Easy Methods)

How to Use SUBTOTAL in Excel with Filters (With Quick Steps)

Feb 9, 2023

This article illustrates how to use the SUBTOTAL function in excel with filters. It is necessary when you need to apply some functions to a filtered ...

How to Use SUBTOTAL in Excel with Filters (With Quick Steps)

How to Sum Columns in Excel When Filtered (7 Ways)

Feb 8, 2023

We use the filter function quite often because of its ability to churn up the most important insights of the data, which helps us immensely to make ...

How to Sum Columns in Excel When Filtered (7 Ways)

How to Sum Columns in Excel Table (7 Methods)

May 8, 2023

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 Sum Columns in Excel Table (7 Methods)

How to Count Columns until Value Reached in Excel

May 17, 2023

Excel is the most widely used tool when it comes to dealing with datasets. It serves us in myriads of ways. In this article, I am going to explain a ...

How to Count Columns until Value Reached in Excel

If Cell Contains Text Then Copy to Another Sheet in Excel

Feb 12, 2023

If you are searching for ways to copy a cell to another sheet in Excel if the cell contains text, then you will find this article useful. Sometimes ...

If Cell Contains Text Then Copy to Another Sheet in Excel

How to Copy Filter Drop-Down List in Excel (5 Ways)

Feb 12, 2023

If you are trying to copy the filter drop-down list in Excel effectively, then this article is for you. Here, we will discuss different 5 ways for ...

How to Copy Filter Drop-Down List in Excel (5 Ways)

How to Count Unique Values in Filtered Column in Excel (5 Methods)

Feb 7, 2023 5

If you have a larger dataset and you need to apply filters in columns. More importantly, you might require to count only unique values except for the ...

How to Count Unique Values in Filtered Column in Excel (5 Methods)

How to Auto Number Cells in Excel (10 Methods)

Mar 2, 2023

There are various ways to auto number cells in Excel. Auto numbering cells mean filling the cells automatically with numbers in Excel. Here we will ...

How to Auto Number Cells in Excel (10 Methods)

How to Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

Feb 27, 2023 6

It's possible that you'll need to count cells based on specific text or formats, such as fill color and font color. Furthermore, you may be required ...

How to Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

How to Count Only Visible Cells in Excel (5 Tricks)

Apr 25, 2023

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

How to Count Only Visible Cells in Excel (5 Tricks)

Excel Formula to Count Colored Cells in a Row (2 Effective Methods)

May 25, 2022

In this article, we will learn to count colored cells in a row with an Excel formula. Sometimes, we need to use colors to highlight certain cells in ...

Excel Formula to Count Colored Cells in a Row (2 Effective Methods)

Count Cells by Color with Conditional Formatting in Excel (3 Methods)

May 25, 2022 4

We may sometimes need to count the Excel cells by Color. That is not hard to do. But, things get complicated when we try to count the cells by color ...

Count Cells by Color with Conditional Formatting in Excel (3 Methods)

How to Count Filtered Cells with Text in Excel (3 Methods)

Feb 16, 2023

We may sometimes need to count the Excel cells with text for different purposes. That is not hard to do. But, things get complicated when we try to ...

How to Count Filtered Cells with Text in Excel (3 Methods)

VBA to Copy Excel Worksheet to Another Workbook without Formulas

Feb 13, 2023 4

In Excel, we often need to copy a worksheet to another workbook without formulas with VBA. We can use both the context menu and VBA for this. Today, ...