Summarize only filtered values using SUBTOTAL & AGGREGATE formulas
We all know the good old SUM() formula. It can sum up values in a range. But what if you want to sum up only filtered values in a range? SUM() doesn’t care if a value is filtered or not. It just sums up the numbers. But there are other formulas that can pay attention to the filters. Let’s learn about them.
Summarize filtered values using SUBTOTAL & AGGREGATE Formulas – video
You may watch this video on our YouTube channel too.
Download Example Workbook
Please click here to download the example workbook. Examine the formulas and play with filters to learn more.
More about Filters, SUBTOTAL & AGGREGATE
Learn more about these features & how they can make you awesome:
- Introduction to SUBTOTAL Formula
- Introduction to Excel Slicers – Visual Filters
- Make dynamic charts with filters
- How to count & sum filtered tables,
- Count & sum with criteria on a filtered list
- Sum up top 3 filtered values using AGGREGATE
- Check if a table is filtered or not using formulas
- Case study – Christmas shopping list
What do you use SUBTOTAL for?
Do you use SUBTOTAL and AGGREGATE functions? What do you use them for? Please share your thoughts in the comments section.
Leave a Reply
|Dynamic Print Areas||Use GETPIVOTDATA to integrate pivot tables with dashboards|