Forum Discussion
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 number of cells that contain this information so I don't have to manually count it each time a change is made. I want a total at the bottom of each column.
Is this possible? It seems like an SUMIF formula, but I am not familiar with these so I don't know how to build the formula. Can anyone out there help me? Send formula to mailto:email address removed for privacy reasons.
Thanks for the help!
Grant
Looking for a total at the bottom of each column
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.
4 Replies
If I understand the objective, a 365 solution may work for you:
=LET(matrix,(data="NLS206A")+(data="NLS2078"),BYCOL(matrix,LAMBDA(col,SUM(col))))- 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 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.
- Thank you for the help. I think I got it.
