Forum Discussion
Solved
Creating a formula from text
I am trying to create a formula that would add up cells that have text in it to give me a total number of cells that have this text. So my cells have info like NLS 201A or NLS 206B I want a total ...
Use the Count formula. See this training tutorial from Kevin Stratvert. He is an incredible trainer.
https://www.youtube.com/watch?v=if4i55JB58M
Scroll to 5:33 on the timeline.
NLS 201A or NLS 206B
sum(201,206)=407?
if so,one way is use vba loop so than clean text NLS and then sum them.
Another way is by sql online,
like
select sum(regepx2('\d+',f01)) from yourTable
sum(201,206)=407?
if so,one way is use vba loop so than clean text NLS and then sum them.
Another way is by sql online,
like
select sum(regepx2('\d+',f01)) from yourTable