I have sheet where i have to find sum of given dynamic range every week and paste the answer in Last or Defined column

eg

Week1: on passing Name/Value of column = 7/8/19, it identifies that Sum of A to B is needed in column Sum(Z) (For all rows)

Week2: on passing Name/value of column = 7/15/19, it identifies that Sum of A to C is needed in column Sum(For all rows)

eg

Week1: on passing Name/Value of column = 7/8/19, it identifies that Sum of A to B is needed in column Sum(Z) (For all rows)

7/1/19 | 7/8/19 | 7/15/19 | Sum | |

1 | 2 | 3 | ||

2 | 3 | 5 |

7/1/19 | 7/8/19 | 7/15/19 | Sum | |

1 | 2 | 2 | 5 | |

2 | 3 | 1 | 6 |

## Comment