adding positive integers in a column or row

  • Thread starter Thread starter jason7100
  • Start date Start date
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!!!! =
 
Hi!

One way:

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

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

Biff
 
You must log in or register to reply here.

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

Excel - Adding positive or negative numbers in a column 5
Numbers showing Up Centered in Cell ? 1
Chart in Excel 2007- Positive & negative value columns 10
Adding only negative numbers in row 3
how do I add only positive numbers in a range 3
Adding Hours 1
Adding Negative and Positive Numbers 4
Subtotal data excluding negitive numbers. 3

Back
Top