Sum function

[dannyboy8]

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?

 

[Shane Devenshire]

Hi,

SUMIF(A1:A10,">0")

 

[Bill Eckert]

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

 

[Gord Dibben]

What type of calculation?

A simple SUM will ignore text.


Gord Dibben MS Excel MVP