MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum function


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.


Posted by Aladin Akyurek on January 25, 2002 8:20 AM

How do you get from A6 to A7? By inserting an additional row maybe? Could you post the formula along with the formula that defines the dynamic range?

Posted by Nancy on January 25, 2002 8:27 AM

Well, I am not so sure about that myself. I am still working on figuring that out. I want the range to move every monday because then i don't need the info from last week. Does that make any sense?

Posted by Nancy on January 25, 2002 1:50 PM

Thank you for your help, Aladin. That proves that we make our lives too complicated sometimes when we don't have to. So, by creating a comparison cell, and match it up, we can change the range. Thank you for your time and effort!!

Posted by Nancy on January 25, 2002 1:50 PM

Thank you for your help, Aladin. That proves that we make our lives too complicated sometimes when we don't have to. So, by creating a comparison cell, and match it up, we can change the range. Thank you for your time and effort!!