MrExcel Publishing
Your One Stop for Excel Tips & Solutions

addition with an unknown range

Posted by dee'd ferman on February 07, 2002 7:25 AM

i am relatively new to the answer is probably under my nose but i don't know...

setting up spreadsheets to track dollar amounts. column c is the amount, and column d is the amount in column c divided by two. not a problem there. here is the problem. is there a way to setup the final formulas, (=sum(c5:c100) and (=c100/2) where i don't have to plug in the final line? each month varies in length of entries, and would like to have a running total as the month goes on, instead of making sure that all have been entered and doing the total line manually.

Posted by Mark W. on February 07, 2002 7:34 AM