11

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

14

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

For instance:

=SUBTOTAL(109;B2:B11)

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

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