Forum Discussion

Comsubin's avatar
Comsubin
Copper Contributor
Nov 12, 2025

Problem creating an Excel formula

I am contacting you because I am having trouble creating a formula to count names in an Excel spreadsheet. I have created a schedule in Excel in which there is usually one name per cell. The calcula...
community
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 12, 2025

Hi

It's always better to share a file, and to mention the version of Excel in use

Assuming you run 365 or Excel Web

in E3:

=REDUCE(0, B3:B12,
  LAMBDA(init,name,
    init + IF( name <> "", COUNTA( TEXTSPLIT( name, "/",, TRUE ) ) )
  )
)

alternatively:

=REDUCE(0, TOCOL( B3:B12, 1),
  LAMBDA(init,name,
    init + COUNTA( TEXTSPLIT( name, "/",, TRUE ) )
  )
)

 

m_tarler's avatar
m_tarler
Bronze Contributor
Nov 12, 2025

another option:

=ROWS(TEXTSPLIT(TEXTJOIN("/",1,A1:A10),,"/",1))

where A1:A10 is the range to check

note this may fail if you have a very large list and reach the total text string length limit (~32k which is about 1.6k names if they average 20 characters each)

Resources