Exclude non-numeric data from calculation

[jostermi]

I have 3 columns: units, numeric grade, and points.
Points are calculated by multiplying units by numeric grade.
Then I divide total points by total units.

Occasionally, I have a non-numeric grade. When that's the case, I wan
to exclude the units from any calculation.

How would I write my formula(s) to recognize this condition?

Basically, I want to say IF(range<>a number,"",range). Which als
brings up the question, is it even possible to use the range operato
in an IF worksheet function, thereby forcing Excel to consider eac
number in the range for any given condition?

Thanks in advance! I hope you're less confused than I am

 

[baldomero]

Try with isnumeric function, returns a boolean value. True if it is
numbe