Hiding characters
 

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

Hiding characters
 

The sum function ignore blank cells.

"KB" wrote:

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

Hiding characters
 

I'm not sure what you are saying. We just got v2007, and I dont know where
anything is in this version. Could you explain?

Thanks!

"Joel" wrote:

The sum function ignore blank cells.

"KB" wrote:

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

Hiding characters
 

You sure you're looking at the right cells?

Any custom format that hides the value in the cell?

And conditional formatting that hides the value in the cell.

===
And something you can ignore...

Add two sheets to your workbook--one to the left of "Work Order Labor1" and one
to the right of "Work Order Labor6".

Call them Start and End.

Then you can use:
=if(ae7=sum('start:end'!ae10),"","X")

I think it makes adding new sheets easier--and it could make the debugging
easier.

You can drag all the worksheets out of that "sandwich". Then drag each in--one
at a time. See which one cause your formula to return X.

And don't forget to look at AE7 of that activesheet!



KB wrote:

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

--

Dave Peterson