Your Challenge: Allocate a Yearly value to Each Month & Category Based on Percentages

The steps for this section's challenge are included in S5_Excel_Formulas_Start.xlsx in the Challenge Tab.

What you need to do:

Write a formula that allocates the yearly profit for all categories to each month based on given monthly percentages AND category distribution.

Let me know how you did! Did you pick the right referencing style?

I share my version in the solution video (coming up next). It's also included in the final version of the workbook for this section: S5_Excel_Formulas.xlsx.