View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default Total column daily

Hello I have a daily report. Every day I add a new line. Presently I have
the formula =SUM(B4:B22) but every day I go in and change the formula to
include the next line. example tomorrow the the formula will read
=SUM(B4:B23) Is there a faster way to do this so that it automatically
updates without having to change the formula daily? thanks