Create dynamic monthly quantities from weekly quantities for multiple data items?

mandchez

New Member
Joined
Nov 26, 2018
Messages
2
Hello,

I am trying to aggregate weekly quantities into monthly ones. THIS LINK shows the dataset in question, the formula I created to aggregate these subsets, and the organization tactic I used.


Is there any way I can make this formula dynamic? I feel like there is an easier way to do this.

Help is greatly appreciated.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,098,845
Messages
5,465,042
Members
406,409
Latest member
windiestboat

This Week's Hot Topics

Top