Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Help Please. Adding ONLY positive or negative numbers.
aliasojo
Posts: 23,053
Forumite
in Techie Stuff
I'd be grateful if anyone could help me with this?
I have 4 or 5 columns (depending on whether it is a 4 or 5 week month).
Each column has several monetary entries and is individually totalled at the bottom. If I overspend, then the totalled amount is a negative amount. If I come in under budget there is a positive amount left.
I have the cells highlighted (using the conditional formatting option) so that a positive amount shows up as green and a negative amount shows up as red. (No idea if that affects anything I want to do now, just mentioned it in case.)
I now want to have a running total so that my total overspend or total underspend is calculated for the month.
Is it possible to format a cell to add either all positive numbers in a range and ignore the negative ones? Or visa versa?
I still have a lot to learn about Excel so please don't assume I will know what you mean if you use short cuts or abbreviations in any replies.
Thanks in advance if anyone can help.
I have 4 or 5 columns (depending on whether it is a 4 or 5 week month).
Each column has several monetary entries and is individually totalled at the bottom. If I overspend, then the totalled amount is a negative amount. If I come in under budget there is a positive amount left.
I have the cells highlighted (using the conditional formatting option) so that a positive amount shows up as green and a negative amount shows up as red. (No idea if that affects anything I want to do now, just mentioned it in case.)
I now want to have a running total so that my total overspend or total underspend is calculated for the month.
Is it possible to format a cell to add either all positive numbers in a range and ignore the negative ones? Or visa versa?
I still have a lot to learn about Excel so please don't assume I will know what you mean if you use short cuts or abbreviations in any replies.
Thanks in advance if anyone can help.
Herman - MP for all!
0
Comments
-
You want to use the SumIf function so to get the positive ones it would be something like:
=SUMIF(C2:C12, ">0")0 -
Thank you so much for taking the time. I have now managed to do what I was after, with your help. :beer:Herman - MP for all!
0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards