Forum Discussion
Using formulas within a filter
Please help! I am charge with doing usage analysis in my company. We have usage stats and make a lot of use of filters. But if I am using a filter, how do I make a formula using only the numbers in a...
I don't know which type of Filter you have been using. IF you are using the relatively new FILTER function you could nest that within a SUM or AVERAGE function and it would count only the cells that met the criteria in the FILTER function. Here are two good places to start to understand the FILTER function (which, by the way, requires the newest edition of Excel).
https://www.youtube.com/watch?v=9I9DtFOVPIg
and
https://exceljet.net/excel-functions/excel-filter-function