O
O
Omiku2018-02-15 12:52:42
Google Sheets
Omiku, 2018-02-15 12:52:42

Google spreadsheets - how to calculate the sum of the values ​​​​of visible cells?

Hello, I keep a record of hits for each article, and if the article fits the question of any of the columns, I put in the cell article 1 which I then sum up "= SUM (K4: K)" and display as a percentage, but when filtering, it still counts all values ​​of the column, which can be specified in the formula, so that when filtering (let's say by the title of the article) it counts the values ​​only in visible cells. In Excel, the issue is easily solved, but we need a solution for Google tables for the main software. Thank you!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
O
Omiku, 2018-02-15
@Omiku

The question was solved by replacing it with = INTERMEDIATE RESULTS (9; K4: K)

T
Tamerlan1, 2020-12-21
@Tamerlan1

This is some kind of nonsense for the average user.
Those. I can't just poke into an empty cell, press the SUM button, and circle the desired range of filtered data. It is necessary to prescribe the formula, look for the SUBTOTAL function that is never in sight, prescribe the first argument - "9" and then only the range.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question