yogi_Sum Up Numbers Several Sheets By Different Dates

Google Spreadsheet   Post  #2220

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-08-2017

question by Benjamin Ohashi :

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/Uqd_Dqn_FXA;context-place=forum/docs

Copying Formula Down

I am trying to copy the following formula down an entire column. When I drag the cursor down it does not copy the formula correctly. 

I need this to carry down column D and E. 

Is there a way to rewrite the formula to be able to drag it down and repeat the formula correctly? 

https://docs.google.com/spreadsheets/d/1vR9Fxoeo8cEW5ChpLnupeneb_YCZ7XKPJ9Yc7qs-y-c/edit#gid=0