« Back to Resources
Google Sheets cheat sheet
How to sum up just visible rows?
- That's useful for example when you filtered your data with the Filter feature and you want to get the sum of a column.
- When using
SUM, Google Sheets includes also hidden rows that have been filtered out by you.
- The solution: use SUBTOTAL
109stands for the
2would stand for
SUBTOTALto omit cells that are hidden
See the official documentation of SUBTOTAL for more info.