LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Fable
 
Posts: n/a
Default Distribute Total


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to total itmes if they fall between a date range cel Excel Worksheet Functions 1 May 17th 05 07:39 PM
How to total items if they fall between a date range cel Excel Discussion (Misc queries) 1 May 17th 05 07:30 PM
Adding Data Using Multiple Worksheets to Total into a Grand Total Lillie Excel Worksheet Functions 1 April 19th 05 08:34 PM
Total remaining formula jbsand1001 Excel Worksheet Functions 2 January 6th 05 04:17 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"