S
SMW
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?
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?