In excel I am wondering how what formula I would use to figure out daily sales percentages.?

[lmwhi]

I have it set up where columns B-H are labeled Sunday-Saturday, and under them are their daily sales numbers.
I want to figure out a formula so I can figure out what Sunday-Saturday are in terms of weekly sales. Like Sunday is 40% of weekly sales, and monday is 15%. Does anyone have any suggestions?

 

[steve the fish]

Adjust these cell references to suit:

=IFERROR(SUM(B1:B50/SUM($B$1:$H$50)),0)

 

[steve the fish]

And format as percentage.