Removing #DIV/0!

**yorkshirekid** · 05-18-2008, 04:06 AM

I have a long row of 18 cells showing me DIV/0. Their values are dependant upon data in another workbook. I only need to enter the values in 6 of the 18 cells, which update the DIV/0 leaving me with 12 I don't need. I want to be able to total the 6 values in that row WITHOUT having to delete the other 12 cell formula's. My question is 2 fold. [1]how do i do this [2] when a formula is placed in a cell I can see values in there (00:00.00) awaiting data input. How do I make it so these values cannot be seen.

It's really hard for me to explain this and so I'm hoping the attached will make it clearer to those who are able to help me. And thank you for this.

**gurusanthanam** · 05-18-2008, 04:54 AM

Pls refer to the attached file....

hope it makes u happy....

regards,
guru

**oldchippy** · 05-18-2008, 04:58 AM

Hi,

Or a little shorter in C3

Please Login or Register  to view this content.

Drag across and down

**yorkshirekid** · 05-18-2008, 05:37 AM

is that you cant give the guys who helped you a hug

Thanks guru - your solution worked. oldchippy, I could not get yours to work. Does not mean that it does not work - it means Im a muppet.......

All i have to do now is enter about a 100 swim times. Here goes........