Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Greetings, I’m trying to distribute from a monthly projected amount of let says “Twinkies” by day. Based on last year performance which is represented by % (percentages) by day of the week (Sun., Mon., Tue., Etc.). Is it possible to input a total amount per month example 1,500 boxes of Twinkies and according to the percentage of the day of the week if would distribute it accordingly? I kind of stumped with variables how many Mondays in a month etc, how t avoids get an incomplete result like in the case 1,498 or 1503 Twinkie boxes. Any help would be deeply appreciated. -- Fable ------------------------------------------------------------------------ Fable's Profile: http://www.excelforum.com/member.php...fo&userid=2185 View this thread: http://www.excelforum.com/showthread...hreadid=389935 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |