SUMIF with broken range
"Wesler" wrote:
I am trying to get three different sums from the same range:
1) All positive numbers
2) All negative numbers
3) The total (which I can get fine)
I tried this all kinds of ways, but the method below
works for the negative numbers, but give me an obscenely
high (and incorrect) number for the positive numbers:
Any ideas?
Your example did not come through my newsreader, at least.
Not sure how "broken" your ranges are. Post your SUM formula (#3). Copy
from the Excel Formula Bar and paste into your posted response.
|