Posted by Nancy on January 25, 2002 8:16 AM
Okay, it's me again. I am still stuck on the same problem. I would like to add entries in a row, the range changes though every week. I know I have to use dynamic named range, but what if some of the cells are empty? Lets say that I have entries in cell A6 through A60, some of them are empty though. How do I get the sum of all the cells with info into cell A61? And what if my range changes next week from A6 to A7 but A60 stays constant as the end of the range.