How do I change my sum formula based on the value in another cell?

[gkisystems]

I'm trying to create a formula the totals up my year to date (YTD) numbers.


In cell DK10, I have the date. In this case, it is 7/1/2013 displayed as "Jul-13." In cell DL14, I have =SUM(CW14:DC14) which adds up the monthly number for January, Feb, March, and so on through July.


What I'm trying to do is get the "DC" in =SUM(CW14:DC14) to change by itself by updating the value in cell DK10. For example, next month cell DK10 will be "Aug-13," so I want this formula =SUM(CW14:DC14) to change to be =SUM(CW14:DD14).


How do I do it? I'm thinking maybe the use of =Indirect(something), but I'm not really sure. Any help would be appreciated.


I'm not really looking to make this any more complicated than it has to be, so I'd prefer using a formula (if possible) over a macro/vba.

 

[spacheco]

Have you tried a sumifs formula instead? put 1/1/xxxx in DK9 and the date you want to go to in DK10 and do a less than or equal to and great than or equal to.

 

[gkisystems]

Have you tried a sumifs formula instead? put 1/1/xxxx in DK9 and the date you want to go to in DK10 and do a less than or equal to and great than or equal to.

Absolutely amazing! I knew had to be something simple, thank you! Here is the formula I used that ended up working:


=SUMIF($CW$11:$DH$11,"<="&$DK$10,$CW14:$DH14)