# distribute evenly among 3 customers

1. ## distribute evenly among 3 customers

Hello to everyone in the forum!

I learned a lot seeing examples and reasoning that they used here on the forum, so I come to answer a question that I haven't been able to solve for months.

I have a column of values ​​that I distribute among 3 clients, and I try to make the sum of each of the 3 as close as possible in the end.

VALUES 1,2,3 CUSTOMER A CUSTOMER B CUSTOMER C
2.00 1 2.00 0.00 0.00
3.00 1 0.00 3.00 0.00
8.00 2 4.00 0.00 4.00
10.00 2 0.00 5.00 5.00
15.00 3 5.00 5.00 5.00
1.00 1 1.00 0.00 0.00

sums 12.00 13.00 14.00

Attached is the spreadsheet of an example that I managed to get distributed between 2, but I can't have any reasoning for it to count as 3 people to be distributed.

Would anyone have a light to help me with this?

2. ## Re: distribute evenly among 3 customers

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

3. ## Re: distribute evenly among 3 customers

AliGW

Thanks for the information.
I edited the publication to aid interpretation

4. ## Re: distribute evenly among 3 customers

See how you get on with this:

=IF(\$J4>=COLUMNS(\$K:K),\$I4/\$J4,0)

or maybe this for your locale:

=IF(\$J4>=COLUMNS(\$K:K);\$I4/\$J4;0)

5. ## Re: distribute evenly among 3 customers

Thanks for the feedback.
Unfortunately the conditional formula didn't work.

I thought it would be simple to do a distribution of values ​​so that in the end the sum would be similar, I'm about to give up on so many options.
I'll keep trying too, if I have any answer I'll let you know on the forum, or let's wait for further attempts

6. ## Re: distribute evenly among 3 customers

Please be patient!!! Other members may have suggestions that better suit your needs.

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

#### 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