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 excel...so 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

Use...

=SUM(C5:INDEX(C:C,MATCH(9.99999999999999E+307,C:C)))
=INDEX(C:C,MATCH(9.99999999999999E+307,C:C))/2