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.
If I understand the objective, a 365 solution may work for you:
=LET(matrix,(data="NLS206A")+(data="NLS2078"),BYCOL(matrix,LAMBDA(col,SUM(col))))