I have two cells that I want to sum, but only if they meet a certain
criteria. However, if they don't meet the criteria I don't want them summed,
nor do I want the cell to say FALSE which is what I've been getting.

96.93% 0.43% 90% 850 38% 53.09
92.89% -3.74% 90% 850 38% 46.47

I want the first two numbers in each row, from left to right, summed, but
only if the second number is negative. If the second number is positive I
want the result to be the same as the first number, kind of like the second
number isn't even there. Is that possible?

=A1+MIN(0,B1)
--
Gary''s Student - gsnu200904

Hi,

=if(B1<0,A1+B1,A1)

"SMW" wrote:

I have two cells that I want to sum, but only if they meet a certain
criteria. However, if they don't meet the criteria I don't want them summed,
nor do I want the cell to say FALSE which is what I've been getting.

96.93% 0.43% 90% 850 38% 53.09
92.89% -3.74% 90% 850 38% 46.47

I want the first two numbers in each row, from left to right, summed, but
only if the second number is negative. If the second number is positive I
want the result to be the same as the first number, kind of like the second
number isn't even there. Is that possible?