Subtotal Function

How to Calculate Percentage of Marks in Excel (5 Simple Ways)

Download Practice Workbook Calculating Percentage of Marks.xlsx 5 Ways to Calculate Percentage of Marks in Excel Our sample dataset ...

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

  We will determine the sum of a column up to the bottom in Excel. We have taken a dataset that shows the store's sales for the month of ...

Sum by Font Color in Excel (2 Effective Ways)

This article illustrates how to sum cells by their font color in Excel. Here's a dataset with various values colored in random colors. We'll sum the ...

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

  Download the Practice Workbook Sum Filtered Cells.xlsm 5 Easy Methods to Sum Filtered Cells in Excel Let's consider a ...

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

  Method 1 - Using the SUM Function to Sum Selected Cells in Excel The following dataset shows sales for different months for a company. We'll ...

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

We have a dataset of some employees. It contains four columns: Employee name, Department, working Hours per day, and Salary. Here’s an overview of ...

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 demonstrate how to count filtered data using the COUNTIF function together with the SUBTOTAL function. Download the ...

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 the Color Function in Excel – Easy Steps

It is possible to make custom functions for calculation based on the color of the cells using the Microsoft Visual Basic for Applications (VBA). ...

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. However, there are a few ways to implement this kind of ...

How to Sum Rows in Excel (9 Easy Methods)

  Download the Practice Workbook You can download the practice workbook from here. Sum Rows.xlsx 9 Quick Methods to Sum Rows in ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo