Answer the question
In order to leave comments, you need to log in
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
Like this, for example:
=ArrayFormula(
ЕСЛИОШИБКА(A:A/A:A;0)+
ЕСЛИОШИБКА(B:B/B:B;0)+
ЕСЛИОШИБКА(C:C/C:C;0)
)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question