How to sum only filtered cells in Excel?

V

V

Vlad2015-12-23 14:53:58

excel

Vlad, 2015-12-23 14:53:58

How to sum only filtered cells in Excel?

I have an excel spreadsheet with numbers.
A2 = heading
Sum(A3:A) is displayed above the column
I want, for example, to filter this column, display only values <20 - how to make the cell with sum(A3:A) after filtering sum only the cells selected by the filter, and not all ?
Something instead of sum(A3:A) should be written...

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

Similar questions

S

Sherzod Abdurakhmonov2020-06-22 11:52:13

How to merge multiple EXCEL files into one table? 3Reply

S

Sergey2016-02-05 09:53:30

How to fix encoding bug when exporting to CSV? 2Reply

S

Sergey Bydanov2020-06-27 06:26:21

How to send data from excel to mysql? 2Reply

A

Alexey Nikolaev2016-02-13 21:00:59

How to write such a condition in Excel? 1Reply

A

anderius2020-07-01 02:40:57

How to make when subtracting two cells with a decimal fraction, in the third cell display the fractional part of the difference as an integer? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question