SUM ONLY NUMBERS IN A RANGE

R

R. Arizpe

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.
 
D

Dave

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SUM + INDEX in array formula 5
Summing all numeric values only in cells in a column 4
SUMIF with criteria "<>" & "=" 4
Need Help with "SUM" AND "ABS" in same formula 12
Sum number range ignoring numbers formatted as text 0
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
SUM ONLY CELLS INA RANGE THAT ARE NUMBERS 6

Top