+ Reply to Thread
Results 1 to 5 of 5

Distribute Numbers

  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Distribute Numbers

    Asking shown in example
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,058

    Re: Distribute Numbers

    You gave only examples for simple SUM.
    Can you give few examples where just SUM won't work but you expect different output?
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Distribute Numbers

    This is another example
    Attached Files Attached Files
    Last edited by shimaa01234; 12-13-2014 at 04:51 AM.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,058

    Re: Distribute Numbers

    It's very similliar example and does not show why =SUM(B8:K8) wouldn't work.

  5. #5
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Distribute Numbers

    Numbers are the same because I want to "distributor" column value of no more than "12" in each column, and if there
    Increase the number "distributor" and less than "12" is placed in the column "J" and not in the column "H"
    I hope that my explanation is clear, sorry about the language

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Distribute Whole Numbers Based on Percentages
    By Optimus21 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-03-2014, 07:00 AM
  2. Evenly Distribute Groups of Numbers?
    By BigBadBoy in forum Excel General
    Replies: 12
    Last Post: 01-14-2014, 08:29 PM
  3. Evenly distribute numbers
    By captain118 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 01:27 AM
  4. Assign and distribute 1,2 or 3 to a range of numbers
    By etaf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-23-2013, 11:57 AM
  5. Divide numbers and distribute evenly.
    By rhon101 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2006, 09:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1