sum up number of times a colon ":" in a row

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Could anyone tell how to sum up the number of times of a colon ":" appeared
in a row.

Thanks.
 
You can drop the leftmost and rightmost parens of Frank's reply
=SUMPRODUCT(LEN(A1:X1)-LEN(SUBSTITUTE(A1:X1,":","")))
instead of
=SUMPRODUCT((LEN(A1:X1)-LEN(SUBSTITUTE(A1:X1,":",""))))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting formula 3
Search for a sum! 4
IF statement with CONCATENATE (I think) 2
vlookup return multiple value 6
Sum numbers in a column beyond a certain row, how to? 6
Pivot table calculated field Count(field) / sum(field) 0
sum 1
Splitting up text in a cell 3

Back
Top