MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum a range of numerics and non-numerics

Posted by Paulo on September 20, 2001 12:00 AM

Hopefully this is simple...
How do I sum a range of values containing numerics and non-numerics. I only want the total of the numeric cells.

Posted by Aladin Akyurek on September 20, 2001 12:22 AM

It's simple. Just use, e.g.,

where A1:A10 houses numeric and non-numeric values (such as text or logicals like TRUE).

SUM ignores non-numeric values. That's why it should work.


Posted by Paulo on September 20, 2001 12:36 AM

Doh! Thanks (NT)