Excel - SUM ONLY NUMBERS IN A RANGE

Asked By R. Arizp on 23-Jun-08 02:21 PM
I have a formula on a range of cells in column K, I want excel to sum the
values of of all the cells in that range; that ARE numbers. (Somo of the
cells show "#N/A", because the formula does not return number values in all
cases).

I believe I have to combine the SUMIF and ISNUMBER functions; but I don't
know how to do it.




Dav replied on 23-Jun-08 02:51 PM
Hi,
One way:
=SUMIF(C4:C11,">0")
If there are negative numbers in your list, then use a negative number much
larger than you will ever have. eg
=SUMIF(C4:C11,">-9E100")
Regards - Dave.