Percentage Formula Help

[lmwhit]

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
21% 6% 6% 4% 10% 6% 50%


total percentages
? ? ? ? ? ? ?


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

[alansidman]

Your posting does not lend itself to a clear understanding of what is in each cell.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic