• 100% Satisfaction Guarantee
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
53785
John D is online now

I am using calc (open office) and I have a spreadsheet provided

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

Customer: replied 6 years ago.
12/20/10 instant Subscription Payment 0 -9 0
12/20/10 instant Subscription Payment 167.87 175 7.13
12/18/10 Recurring Payment -99 -99 0

The 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