Formula headache - Do not show SUM result if a cell in this SUM is left empty -

For an event budget I've added a column invoice.

The SUM =SUM([Subtot inc BTW]8 - Factuur8) compares the quotation with the invoice
However I'd like to find a way that the column only shows the result of the SUM after an invoice ammount is typed in. Since a lot of cells are left blank in the column invoice the above SUM will show the result of the quotation compared to the blank cell, thus showing a big difference. Is there a formula that will not display the SUM if a cell in this SUM is left empty ?

Find more posts tagged with

Project Management

Comments

JamesR

=if(isblank(cellref),0,cellref-cellref)

As a note your original calculation did not need the sum function.

=cellref-cellref would have given you the same answer.