Hi,
I'm trying to build a function that sums QTD based on weeks.
This is my formula, which keeps coming back false:
=IF($DD$76<=13,SUM(BC81:INDEX(BC81:BO81,DK81),IF($DD$76<=26,SUM(BP81:INDEX(BP81:CB81,DK81),IF($DD$76<=39,SUM(CC81:INDEX(CC81:CO81,DK81),IF($DD$76<=55,SUM(CP81:INDEX(CP81
B81,DK81)))))))))
in DD75, I input the week of year that we're in.
BC81:BO81 is Week 1 - week 13 data, and so on.
When I put in a week, I want it to sum QTD up to that particular week. Column DC has week of the quarter in it.
Its a bit of a mess. I'd appreciate any help!
I'm trying to build a function that sums QTD based on weeks.
This is my formula, which keeps coming back false:
=IF($DD$76<=13,SUM(BC81:INDEX(BC81:BO81,DK81),IF($DD$76<=26,SUM(BP81:INDEX(BP81:CB81,DK81),IF($DD$76<=39,SUM(CC81:INDEX(CC81:CO81,DK81),IF($DD$76<=55,SUM(CP81:INDEX(CP81
B81,DK81)))))))))in DD75, I input the week of year that we're in.
BC81:BO81 is Week 1 - week 13 data, and so on.
When I put in a week, I want it to sum QTD up to that particular week. Column DC has week of the quarter in it.
Its a bit of a mess. I'd appreciate any help!