Excel Pro Trick: How to Calculate Filtered or Visible cells?

When a filter is applied to a table of data, it hides certain rows of data,
But when you perform any calculations to those visible or filtered cells, it calculates all the data, instead of calculating only those filtered results.
This video helps you calculate Filtered or visible cells.
Calculations to filtered cells/visible cells can help you work more efficiently and effectively with large sets of data in Excel.
And allow you to focus on the data that is most relevant to your analysis by making it easy to create dynamic reports that update calculations automatically as you filter the data.
#exceltips #exceltricks #exceltutorial

[@jaffaralbahadly558]

Great 🎉