Sum function
 

If i have a row of positive and negative #s, and I want to sum up this row,
but only include the positive #s in the sum, how would I go about doing this?

Sum function
 

Hi,

SUMIF(A1:A10,"0")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dannyboy8" wrote:

If i have a row of positive and negative #s, and I want to sum up this row,
but only include the positive #s in the sum, how would I go about doing this?

Sum function
 

-- If I have several columns that I wish to calculate and a text word is
used in one column, what formula can I use without getting an error.
Bill Eckert


"dannyboy8" wrote:

If i have a row of positive and negative #s, and I want to sum up this row,
but only include the positive #s in the sum, how would I go about doing this?

Sum function
 

What type of calculation?

A simple SUM will ignore text.


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 13:24:01 -0700, Bill Eckert
(donotspam) wrote:


-- If I have several columns that I wish to calculate and a text word is
used in one column, what formula can I use without getting an error.
Bill Eckert


"dannyboy8" wrote:

If i have a row of positive and negative #s, and I want to sum up this row,
but only include the positive #s in the sum, how would I go about doing this?