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

	sunday	monday	tuesday	wednesday	thursday	friday	saturday
			1	2	3	4	5
			100	0	138	557	1127
percentages			5%	0%	8%	29%	59%
	6	7	8	9	10	11	12
	745	232	185	90	310	159	1660
percentages	21%	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.

 

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