Sumif question, I think

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top