Forum Discussion
Excel Filter and Sum Function
I have a question regarding MS Exel filters and sum function. After a filter is applied to a sheet there is a list of rows that are displayed that meet the criteria of the filter. These rows have...
Hi,
Better to publish that question for Excel community here on TechCom.
To sum you may use
=SUBTOTAL(9,A:A)
or
=AGGREGATE(9,7,A:A)
I'm moving this question to the Excel community for better visibility.