#### Addictions

##### Board Regular

- Joined
- May 27, 2018

- Messages
- 58

- Office Version
- 365

Hello,

I am trying to find week number in C1 and match it in column A. Then sum all cells below to the end in column D. In this example it is sum of D8:D11.

Is this possible to do?. The week number is going to be changing and would want to know the remaining amount for remaining weeks basically.

It is basically a vlookup but how to do it to include a sum of all cells below also?,

Please help

<tbody>

</tbody>

I am trying to find week number in C1 and match it in column A. Then sum all cells below to the end in column D. In this example it is sum of D8:D11.

Is this possible to do?. The week number is going to be changing and would want to know the remaining amount for remaining weeks basically.

It is basically a vlookup but how to do it to include a sum of all cells below also?,

Please help

A | B | C | D | |

1 | Current Week | 29 | ||

2 | Week | Data 1 | Data 2 | Data 3 |

3 | 24 | 1 | 1 | 1 |

4 | 25 | 2 | 2 | 2 |

5 | 26 | 3 | 3 | 3 |

6 | 27 | 4 | 4 | 4 |

7 | 28 | 5 | 5 | 5 |

8 | 29 | 6 | 6 | 6 |

9 | 30 | 7 | 7 | 7 |

10 | 31 | 8 | 8 | 8 |

11 | 32 | 9 | 9 | 9 |

<tbody>

</tbody>

Last edited: