programsam
Board Regular
- Joined
- Feb 10, 2016
- Messages
- 123
Greetings, hopefully the illustration below sort of paints the picture.
I'm wanting to have Excel calculate the % of plan (Column K) contribution for each day (Column J) in a given month (Column H) by business unit (Column E). So essentially, it would look something like this.
01/01/2022 - 3.56%
01/02/2022 - 2.02%
01/03/2022 - 1.98%
all the way down to 12/31/2022 (but each month would total 100%)
I'm wanting to have Excel calculate the % of plan (Column K) contribution for each day (Column J) in a given month (Column H) by business unit (Column E). So essentially, it would look something like this.
01/01/2022 - 3.56%
01/02/2022 - 2.02%
01/03/2022 - 1.98%
all the way down to 12/31/2022 (but each month would total 100%)