Using functions such as Sum, Average and Count in Excel is fine until you need to apply those functions to filtered data. That's when the trouble starts as these functions ignore the filter and return the results for the entire range. In this situation, the SUBTOTAL function is your friend.
🗒 Notes and Resources
Download a copy of the files used in this video: [ Ссылка ]
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at [ Ссылка ]
🙋♂️ Let's connect on social
Twitter: [ Ссылка ]
Facebook: [ Ссылка ]
LinkedIn: [ Ссылка ]
#excel #subtotal #filter
