Formula Help

lmwhi

New Member
I am trying to figure out the formula to calculate overall monthly percentages. The Columns go from B to H

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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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.

i have the weekly totals

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.

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

Re: Percentage Formula Help

bump

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

Replies
5
Views
324
Replies
3
Views
572
Replies
0
Views
239
Replies
5
Views
400
Replies
3
Views
367

1,196,487
Messages
6,015,487
Members
441,898
Latest member
kofafa

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.

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

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