Formula Help

lmwhi

New Member
Joined
Sep 5, 2014
Messages
6
I am trying to figure out the formula to calculate overall monthly percentages. The Columns go from B to H

B2-H2 are just headings, Sunday-Saturday
B4-H4 are sales numbers
B5-H5 are percentages of the week, so monday is 10% of weekly sales and so on.
B9-H9, B13-H13, B17-H17 and B21-H21 are all the other percentages for the other weeks in the month.

At the bottom I have a spot for overall percentages. So I need to know how to figure out monthly monday sales, tuesday monthly sales, and so on.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You cannot weight average percentages. The same amount of Monday sales could be different percentages each week. you need the weekly totals to produce a valid weight average.
 
Upvote 0
Percentage Formula Help

sundaymondaytuesdaywednesdaythursdayfriday saturday
12345
10001385571127
percentages5%0%8%29%59%
6789101112
745232185903101591660
percentages21%6%6%4%10%6$50%
total percentages

<tbody>
</tbody>


I am trying to find the total percentages for the month, so what tuesday sales are in the month, what wednesday sales are, etc.
 
Upvote 0
Re: Percentage Formula Help

I merged your last post in with your original question. Please note that all clarifications, follow-ups, and bumps should be posted back to the original thread (do not start a new thread on the same question -- thread of a duplicate nature will typically be locked or deleted).

Thanks
 
Upvote 0
Re: Percentage Formula Help

Assuming that you have Sunday in column B and there are 5 weeks, then you can put this formula in

B17 = "=SUM(B15,B12,B9,B6,B3)/SUM(SUM($B3:$H3),SUM($B6:$H6),SUM($B9:$H9),SUM($B12:$H12), SUM($B15:$H15))"
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top