How to correct DLSTR formula in Excel?

Question

excel

Am I writing the formula wrong? Gives an error
=Lstr(D3:D4)
=len(D3:D4)
on the screen there is a typo DLSTR

Answer 1

Alt + F11 , right click Insert → Module and in this module we write:

Function СРДЛВСЕХСТРОК(parRange As Range)
 i = 0
 countLine = 0
  For Each c In parRange
    countLine = countLine + Len(c)
    i = i + 1
  Next
 СРДЛВСЕХСТРОК = int(countLine / i)
End Function

After that, you have a new function AVERAGEALLROWS , which can calculate the average value of characters in the specified range