Formula Help

[lmwhi]

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.

 

[par60056]

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.

 

[lmwhi]

i have the weekly totals

 

[lmwhi]

Percentage Formula Help

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]sunday[/TD]
[TD]monday[/TD]
[TD]tuesday[/TD]
[TD]wednesday[/TD]
[TD]thursday[/TD]
[TD]friday [/TD]
[TD]saturday[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]100[/TD]
[TD]0[/TD]
[TD]138[/TD]
[TD]557[/TD]
[TD]1127[/TD]
[/TR]
[TR]
[TD]percentages[/TD]
[TD][/TD]
[TD][/TD]
[TD]5%[/TD]
[TD]0%[/TD]
[TD]8%[/TD]
[TD]29%[/TD]
[TD]59%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]745[/TD]
[TD]232[/TD]
[TD]185[/TD]
[TD]90[/TD]
[TD]310[/TD]
[TD]159[/TD]
[TD]1660[/TD]
[/TR]
[TR]
[TD]percentages[/TD]
[TD]21%[/TD]
[TD]6%[/TD]
[TD]6%[/TD]
[TD]4%[/TD]
[TD]10%[/TD]
[TD]6$[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]total percentages [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I am trying to find the total percentages for the month, so what tuesday sales are in the month, what wednesday sales are, etc.

 

[Joe4]

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

 

[lmwhi]

Re: Percentage Formula Help

bump

 

[par60056]

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))"