SUM ONLY POSITVE #s

[mechpm]

I HAVE A WORKSHET THAT IN ROW D WE NEED TO ADD ONLY THE POSITIVE #s AND IN ROW E WE NEED TO HAVE ONLY THE POSITVE #s RETURNED. ROW E IS FED BY A FORMULA =(D - C)/C TO RETURN % DIFF.

THX,

R W

[ This Message was edited by: mechpm on 2002-05-17 05:31 ]

[crimlet]

On 2002-05-17 05:25, mechpm wrote:
I HAVE A WORKSHET THAT IN ROW D WE NEED TO ADD ONLY THE POSITIVE #s AND IN ROW E WE NEED TO HAVE ONLY THE POSITVE #s RETURNED. ROW E IS FED BY A FORMULA =(D - C)/C TO RETURN % DIFF.

THX,

R W

[ This Message was edited by: mechpm on 2002-05-17 05:31 ]

i'm not entirley sure what you want, but could you use something along the lines of =SUMIF(C3:C8,">0"), this will add the numbers in the given range if they are greater than 0

[mechpm]

On 2002-05-17 05:45, crimlet wrote:

i'm not entirley sure what you want, but could you use something along the lines of =SUMIF(C3:C8,">0"), this will add the numbers in the given range if they are greater than 0

YES, THANK YOU THAT WOULD WORK IN COLUMN D.

IN C WE HAVE LOW BID AND IN D WE HAVE SECOND LOW BID. WE USE =(D-C)/C TO RETURN THE % DIFFERANCE. WE DO NOT WANT ANY NEG. #s RETURNED, IN THAT, WE ARE NOT THE LOW BIDDERS AND WE COULD NOT POSSIBLY GET THAT LOW.

THX

RW