How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
Type Your Question Here...
John D is online now
A new question is answered every 9 seconds

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

This answer was rated:

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.



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.



Use this for total positive in column E



and this for total negative



Hope this helps.thank you for clicking Accept if you are satisfied with the solution



John D and 20 other General Specialists are ready to help you