In Google Sheets, if you want to count the sum of the number of lines in all cells in column A, this function can be used:
What’s the equivalent in Excel 2019? I tried the same function, and it doesn’t work and shows the result as
Code:
=counta(A1:A) + sum(arrayformula(len(regexreplace(A1:A, "[^\n]", ""))))
What’s the equivalent in Excel 2019? I tried the same function, and it doesn’t work and shows the result as
#NAME
?