Use these methods for your problem. Learn how to use excel formulas like subtotal to calculate sums, averages, and more on visible cells only, ignoring hidden or filtered data. You can simply recalculate by selecting the cell with the formula, going into cell edit mode, and pressing the enter key
How to Select Visible Cells Only in Excel? 3 Easy Ways + Shortcut!
To sum it up, those were some easy ways to sum only filtered or visible cells in excel.
In excel, to sum values only from the visible cells (that means when you have applied a filter), you need to use the subtotal function
With this function, you can refer to the entire range, but the moment you apply a filter, it works dynamically and show the sum only for the visible cells. Conclusions selecting only the visible cells from a range is an important first step if you want to copy and paste values from a range that contain hidden rows or columns You can quickly reduce your selected range to only the visible cells with a shortcut, the go to menu, or the quick acess toolbar.
