Recent Feedback
I am using calc (open office) and I have a spreadsheet provided by paypal. It has transactions and shows net, gross, fees. But the negative numbers from payments from my account are offsetting the positive numbers paid to my account.I need to total in a column how much came in and also how much is negative (went out)...not the offset. What formula do I use? If you know excel and can do it there that would work as well.
Hi,
Please post the data and identify the column letters
12/20/10 instant Subscription Payment 0 -9 012/20/10 instant Subscription Payment 167.87 175 7.1312/18/10 Recurring Payment -99 -99 0The numbers are net, gross, fees. D, E, F for those columns. I need to know total negative under each, as well as total positive for each.
OK,
Use this for total positive in column E
=SUMIF(E1:E3,">0")
and this for total negative
=SUMIF(E1:E3,"<0")
Hope this helps.thank you for clicking Accept if you are satisfied with the solution
Experience: Math, science and 25 years experience in computer programming