this is driving me crazy. i use an Excel sheet for accounting purposes for my business. basically the cells are from left to right- Invoice #, invoice date, invoice $, date received. Before they're received, I highlight the cell of the invoice # in yellow to show me that it's outstanding and to follow up with the customers. What I want to do, at any one time, is show how much we have outstanding in open invoices and not sure how to do it.
One way I thought was to add another cell, with a pull down of either Yes or No. Yes= invoice paid, No= invoice open. I can then create an IF THEN statement or something that would only add that $ value into a sum if it's still open or No was selected.
The other way I thought which I know is more complicated is to have it sum only when the invoice # is highlighted in yellow.
Any thoughts?
One way I thought was to add another cell, with a pull down of either Yes or No. Yes= invoice paid, No= invoice open. I can then create an IF THEN statement or something that would only add that $ value into a sum if it's still open or No was selected.
The other way I thought which I know is more complicated is to have it sum only when the invoice # is highlighted in yellow.
Any thoughts?