As per question title, how to sum only the visible cells on Google Spreadsheets?


I found the solution, to use the SUBTOTAL function and using 109 as its first argument.

For instance:


will sum the only shown values in the B2:B11 interval.

  • Note that per the docs, 1) it is a comma that separates cell range from subtotal type, not a semicolon; 2) the prefix "10" is unnecessary, so you could also use =SUBTOTAL(9, B2:B11) – Oliver Jan 10 at 2:55
  • 3
    @Oliver In german it is ; because , separates whole numbers from their fractional parts. – RedX Feb 28 at 12:34
  • Good to know thx – Oliver Feb 28 at 19:32

Not the answer you're looking for? Browse other questions tagged or ask your own question.