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
  • Example =SUBTOTAL(109, A2:A100)
    • the 9 in the 109 stands for the SUM function, a 2 would stand for COUNT
    • the 10 in the 109 tells SUBTOTAL to omit cells that are hidden

See the official documentation of SUBTOTAL for more info.

« Back to Resources