1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do ignore inconsistent text in a column and just sum the numbers?

I have a stats sheet I use for football and the formula I have been using to ignore any text in the cells and just count the numbers isn’t working anymore. I was using eg. =SUM(—TEXTSPLIT(Z3:Z48,”,”)). There are different, inconsistent strings of text in each cell that mean I cannot just sub out the same text for each cell. I want to sum all the ‘minutes’ and ignore text like the Comma, “A”, “G”, “Y”, “R”. An example of a cell would be ‘90, A, Y’ and I would like to add the 90 and ignore the text.

submitted by /u/Apprehensive_Bid3658
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article