Excel - Percent of Totals

[ZackStrowbridge]

I have a problem with percent of total in excel...

....................January.........February.......... March ........ Product Total .......... % of Total
Toppings ...... $19,314 .......... $21,698......... $18,742........... $59,754..................... ?
Condiments .... 21,668 ........... 18,752 ...........20,950........... $61,370 .....................?
Desserts ..... ....23,661 ............24,080.......... 25,900............ $73,641 ....................?
Sauces ........... 15,774 ............14,883 ...........16,902 ............$47,559................... ?
Herbs .............. 16,500 ............17,010 ...........16,823 ...........$50,333 ................... ?
Month Tot. ...... $96,917 ..........$96,423 ..........$99,317
​

I do know that % of total is PRODUCT TOT/MONTH TOT but i don't kno which month, or if I add up all months...let me know asap, thanks!

(this is from "Go! With Microsoft Excel 2010" problem 2K - incase someone has the book)

 

[Dryver14]

You would ahve to have three seperate columns to show the different months unless you put the names of the months in a drop down and then referenced that.

 

[CWatts]

Divide your product totals by the sum of your three month tots, which will give you the percentage of toppings etc for the quarter.