The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.

Hi,in this session i am going to cover, how to use sub total feature in openoffice calc and excel.let's take an example- i have a data of employees name, month of joining and salary. i want to get ...

Hi,in this session i am going to cover, how to use sub total feature in openoffice calc and excel.let's take an example- i have a data of employees name, month of joining and salary. i want to get ...

# Subtotal function (used in tables) what is the function num? I frequently use little tables, particularly to format data in preparation for sending in an email. I just needed to add a subtotal row, ...

Subtotal function (used in tables) what is the function num? I frequently use little tables, particularly to format data in preparation for sending in an email.

Here at Enterprise times we get reports that may have thousands of lines of data. There are many times that we need to know just how many times a certain item, person or number appears in the data.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function ...