A
A
Alexey Mikhailov2020-08-25 17:07:34
Google Sheets
Alexey Mikhailov, 2020-08-25 17:07:34

How to count number of numbers in strings using array formula?

In three columns: A, B, C - each cell is randomly worth any number or nothing.

In column D, you need to count the number of cells filled with numbers on each row. This is done by the formula =COUNT(A1:C1) The

question is how to do this using ArrayFormula so as not to stretch the formula to all cells?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Grigory Boev, 2020-08-25
@DPhil

Like this, for example:

=ArrayFormula(
  ЕСЛИОШИБКА(A:A/A:A;0)+
  ЕСЛИОШИБКА(B:B/B:B;0)+
  ЕСЛИОШИБКА(C:C/C:C;0)
)

Demo table

A
Alexey Mikhailov, 2020-08-26
@DPhil

Grigory Boev , this is incredible! Just unbelieveble.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question