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

Sergey2016-09-21 14:17:51

What is the formula for changing date type? 1Reply

I

Ivan Melnikov2019-02-22 14:23:09

How to make a cell with a date (date type) a text cell in Excel 2013 so that the date is displayed in the same way? 2Reply

P

pfedorov0310902022-04-12 10:23:57

Formation of a document according to a template? 1Reply

N

nivaech2020-11-20 14:09:48

How to compare two cells in Excel and display non-repeating values? 4Reply

I

Igor2016-09-25 12:03:29

How to configure hotkeys in excel 2010 if there is no such item? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question