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?