Sum only numbers

[Rehan Akhtar]

I have data that has numbers and names (in separate
cells) and I just need to add up the numbers in the
range..

Solution!!!

Rehan

 

[Aladin Akyurek]

Just

=SUM(Range)

for SUM() ignores text values like names.