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

M

madentixx2022-04-19 21:50:36

excel

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

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

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2022-04-19
@madentixx

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