G
Guest
my formula in A1 on a summary page is....
=(IF(Mon!$G8="","",(Mon!E8)))
the formula in B1 is the same, except if references Tues! etc for C1 is
Wed!, D1 is Thurs!, etc.
However, when G8 is blank, A1, B1 etc is not blank also, but shows DIV/0!
So, when I go to add A1 through G1 (mon-Sunday), I also get DIV/0!
I've tried putting 0's in the G8's on the Mon, Tues....sheets, no luck.
I'm sure it's something simple, but I can't see it.
Thanks
=(IF(Mon!$G8="","",(Mon!E8)))
the formula in B1 is the same, except if references Tues! etc for C1 is
Wed!, D1 is Thurs!, etc.
However, when G8 is blank, A1, B1 etc is not blank also, but shows DIV/0!
So, when I go to add A1 through G1 (mon-Sunday), I also get DIV/0!
I've tried putting 0's in the G8's on the Mon, Tues....sheets, no luck.
I'm sure it's something simple, but I can't see it.
Thanks