Subtotal Function Archives

Sum to End of a Column in Excel (8 Handy Methods)

May 16, 2022 Excel Formulas

This article is all about determining the sum of numeric values to the end of a column in Excel. We can perform this using different functions and ...

Sum by Font Color in Excel (2 Effective Ways)

Apr 28, 2022 Advanced Excel

This article illustrates how to sum cells by their font color in excel. If you have multiple cells with varied font colors, then you might need this. ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Apr 27, 2022 Excel Formulas

Sometimes it becomes a necessity for us to know the sum of some filtered cells. Though we can do it manually, Excel has some fantastic features to ...

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

Apr 27, 2022 Excel Formulas

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 Use SUBTOTAL in Excel with Filters (With Quick Steps)

Apr 28, 2022 Excel Basics

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 Sum Columns in Excel When Filtered (7 Ways)

May 10, 2022 Excel Formulas

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 Table (7 Methods)

May 10, 2022 Excel Formulas

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 Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

May 25, 2022 Excel Formulas

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 Only Visible Cells in Excel (5 Tricks)

May 25, 2022 Excel Formulas

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 Filtered Cells with Text in Excel (3 Methods)

May 25, 2022 Excel Formulas

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

VBA to Copy Excel Worksheet to Another Workbook without Formulas

May 25, 2022 Macros & Excel VBA

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

How to AutoFill Numbers in Excel with Filter (2 Methods)

May 25, 2022 Excel Basics

We often need to work with huge datasets in Excel. AutoFilling numbers with Filter can make our task much easier. So, we should know how to AutoFill ...

Excel Formulas to Fill Down Sequence Numbers Skip Hidden Rows

May 25, 2022 Excel Basics

Sometimes we need to hide some unnecessary rows in Excel to present the information. There we frequently face a problem filling down the sequence ...

How to Auto Number or Renumber after Filter in Excel (7 Easy Ways)

May 25, 2022 Excel Basics

We often use Filters in Excel to sort data. Sometimes we may need to arrange data from smaller to bigger or vice versa. It is tiresome to arrange ...

How to Calculate Percentage in Excel Based on Cell Color (4 Methods)

May 25, 2022 Excel Basics

Sometimes, in our Excel worksheet, we need to calculate the percentage based on cell color. In this article, we’ll show you the simple methods to ...