Excel - Summing Up Totals based on a rolling dates

[nicksrk]

Good Morning,

I would like some help or advice with a basic excel spreadsheet I am to build.

On a worksheet I have columns for week numbers and within each week number I am entering values.

On another week sheet I have summary sheet where I want to display the current month's week number from previous worksheet and then adding up the values with totals.

I have example spreadsheet to display but I thought you could add attachments.

Thanks

 

[Joe4]

No, you cannot upload/attach file, but you can post images using the tools mentioned here: https://www.mrexcel.com/forum/about-board/508133-attachments.html

Note that depending on how your data is laid out, you maybe be able to use the SUMIF (or SUMIFS) formula to sum up the records matching your criteria (week number).
See: https://www.techonthenet.com/excel/formulas/sumif.php