adding positive integers in a column or row

J

jason7100

Hi Excel Guru!

I have template that needs some fine tuning, how can I compute for th
sum of + integers ONLY. adding all cells including te ones wit
negative values will screw up my computations.

Thanks!!!! =
 
B

Biff

Hi!

One way:

=SUMIF(A10:A14,">0")

Translated: sum the numeric values in the range A10 thru
A14 that are greater than zero.

Biff
 
Top