SUBTOTAL Function

8 Ways to Count Duplicate Values in Multiple Columns in Excel

Microsoft Excel is the most useful data-tracking software. For datasets that have numerous worksheets or users or identity numbers, it is difficult ...

Calculate Percentage in Excel Based on Conditional Formatting

In this article, I'll show you three excellent methods for how to calculate the percentage value in Excel based on the conditional formatting ...

4 Easy Ways to Calculate Percentage in Excel Based on Cell Color

Sometimes we have to calculate the percentage of a certain value from the total value. It can be a certain sell value of a product from all the ...

4 Easy Ways to Insert a Total Row in Excel

We often need to know the total value from a certain dataset in Excel. We can use it to determine the cost or revenue of a company. It can be the ...

9 Ways to Count Rows with Text in Excel

In this lesson, I'll demonstrate 9 effective approaches on how to count rows and also cells with text in Excel. Moreover, these techniques will ...

7 Easy Ways to Sum Colored Cells in Excel Without VBA

Sometimes we need to process data in Excel quickly by coloring them. We may want to count the number of colored cells or the values of the cells. ...

7 Ways to Count Duplicates in Two Columns in Excel

Organizing data using various techniques is quite common in Microsoft Excel. Records are arranged in a tabular form here. In cases of data tracking, ...

2 Ways to Hide-Unhide Columns in Excel with Plus-Minus Sign

When we are handling a large spreadsheet in Excel, we need to hide and unhide columns to get relevant information easily. In this article, we will ...

3 Ways to Auto Number or Renumber After Filter in Excel

Using Filter is a widely used feature in Excel. However, if our dataset contains serial numbers, the serial numbers remain the same as before after ...

5 Ways to SUM Last 5 Values in Row in Excel

Doing SUM in Excel is a common thing, but sometimes you want to SUM the final 5 values in row. For a big dataset, this can be a gruesome thing to do. ...

ExcelDen
Logo