Excel #DIV/0! Error

[LaneyL2868]

I have a couple of questions.

The first one is i continue to get the error #DIV/0! error in several cells/workbooks. One of the formulas in the cell is blank and it's trying to divide the blank cell with nothing - hence why I am getting the error. However, that Error Message carries onto the other Spreadsheet for the "Yearly" information i am trying to obtain. How can i resolve this error so that it will post either nothing or 0.00?

 

[etaf]

use an IF or an IFERROR()

 

[DaveBurnett]

Test for an empty?/blank cell before doing the sum is what Wayne is saying.