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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Dynamic Print Areas||How to use GETPIVOTDATA with Excel Pivot Tables »|