SUMIF with broken range
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?
|