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.


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