How to implement counting the number of filled cells in several ranges and adding the resulting numbers in one formula?

M

M

madentixx2022-04-19 21:50:36

excel

madentixx, 2022-04-19 21:50:36

How to implement counting the number of filled cells in several ranges and adding the resulting numbers in one formula?

There are several plates on one sheet, in each of them you need to count the filled cells in the first column, and immediately add all these values so that the output is the total number of filled cells in all the first columns of these plates.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2022-04-19
@madentixx

=COUNTIF( range1 ; "<>")+COUNTIF( range2 ; "<>")

Similar questions

R

random_object2019-05-23 12:08:25

How to compare two columns with urls in excel? 2Reply

V

Viktor Familyevich2017-01-11 12:22:37

How to work with Excel in C#? 2Reply

K

Kevin Kostner2017-01-12 07:38:08

How to give links to a range of cells using data from another table? 2Reply

J

janraev2017-01-13 19:02:58

How to import the number of subscribers from a VK group to Google Sheets? 2Reply

A

Alexander Shilov2019-06-17 11:12:24

Where can I find the PROGNOZ Add-in for Excel? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question