I have a multipage spreadsheet. On the cover sheet (sheet 1), I set up a cell
to add up certain cells on sheets 2-6 using =IF(AE7=SUM('Work Order
Labor1:Work Order Labor6'!AE10),"","X"). So as you can see if AE7 ont he
cover sheet does not match the total added amount of Work Order Labor1
through 6, the cell will have an "X" in it. If the number match, the "X" will
not show.
The problem is that when theres nothing in any of the cells, in theory it
should be a match of 0 and 0. But the X still shows up in the cell. If I put
8 in AE7 and the put 2 on the other pages equalling 8 the X does disappear as
it is supposed to.
Why does the X appear when no values are present? And How would you fix it?

Thanks