Setting up a formula to skip over non-numeric values

Regular Visitor

Looking for a solution on a formula that would allow me to skip over non numeric values that might appear in a cell. I don't want to strip this data out of these cells or replace it with other information. I simply want it to skip over any non-numeric data detected and allow the formula to continue to work. Is there a way to accomplish this? IF or ISNUMBER won't accomplish what I need. Thank you.

2 Replies


Can you explain what you want your formula to do? Count values, sum values, filter values, ...?

Please provide clear and detailed information.


The goal isn't clear.  I'm guessing you want to keep a cell's contents but have a formula read only the numbers in an alphanumeric? If that's the case, this might work.


365 solution: