- Joined
- Nov 28, 2009
- Messages
- 14,762
- Reaction score
- 951
I have a page of data (downloaded bank statement.)
One column contains numbers: Positive numbers are money paid in, negative numbers is money paid out.
I want to add up all the positive numbers into one total (money paid in over a year) and separately add up all the negative numbers (money paid out over a year) into a second total.
How can I do it short of very clumsilly doing lots of if's to separate money in and money out into separate columns, which would then be easy to total separately.
One column contains numbers: Positive numbers are money paid in, negative numbers is money paid out.
I want to add up all the positive numbers into one total (money paid in over a year) and separately add up all the negative numbers (money paid out over a year) into a second total.
How can I do it short of very clumsilly doing lots of if's to separate money in and money out into separate columns, which would then be easy to total separately.
