I have the following situation that is helping substantiate Einstein's definition of crazy...
I have created an invoicing system to help me along in my small business. The problem is, I believe, that I'm attempting to sum a column that has numbers derived from a formula. Example:
Screen Shot 2019-03-28 at 11.12.24 PM.png
Basically I have added the column and want to subtract payments and deposits in order to arrive at "Total Due on Completion" cells formula: =IFERROR(SUM(I13:I57-I58),"0")
and it is not picking up on "DEPOSITS" OR "PAYMENTS". Before I placed the "IFERROR" formula the error message was "VALUE#"
Whatever it is I'm guessing that one of you excel masters will quickly have an answer to put me out of my misery.
Bookmarks