I am using my Google Spreadsheet to keep tabs of my incomming and outgoing money. I've made a row with ~19 cells in it, in those 19 cells I have the monthly what comes in and what goes out. At the end I add this all up and then subtract a different cell that adds up random costs.
But my problem here is that the calculation
=SUM(C4:C17) counts everything, even the money that has not come in or that was spend. But I don't want to fiddle around with that calculation all the time.
Is it possible to make every cell in row C red and when it’s red it does not count (so it will be ignored) but if I make the cell green it gets added in the grand total?