Calculate the % of Total Using Absolute Cell References
When you want to see daily sales as a percentage of a total, use Absolute Cell References in your formula.
Visit my website -
http://thecompanyrocks.com/excels
to view all of my Excel Video Lessons.