This is an NFL office pool, just trying to clean the code up a little, i figured out how to return the highest value in row 6 (total score for all weeks), but what i'd like to do is be able to add up the weeks without having the current value in weeks that haven't played yet (rows below the "JEFF S" row are doing what i'm trying to fix). If I can get help with this to at least return a 0 then i can make a conditional format for that cell to return white coloured 0, or even better to get a code that just doesn't display a value if = 0.
thank you kindly in advance
breal33
Bookmarks