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

V

Vitaly2017-07-20 23:58:56

Where can I get the promo code auto-mailer script from the xls-table using Outlook? 1Reply

G

Groofy2015-08-14 11:08:41

How to match two tables? 1Reply

D

dk-web2015-08-16 13:06:44

How to correctly write Russian and French into MySQL from Excel? 2Reply

A

Anton AK2015-08-16 17:13:09

Where to store data for connecting to the database? 0Reply

V

Veritas232019-12-29 11:48:00

How to select cells in Excel that contain one of the specified words? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question