Formula to work out an exact average over an exact number

[Sandyshirl]

I need a formula to work out an exact average over a column of numbers. eg:

Column B has the total amount for each person
Column C(with my current formula), =ROUNDUP(($D$2/$B$10)*B3,)

Column D has my exact allocated number. At the moment this is (11)
I need the total of column C to always be the same as the allocated number in column d.

11
Carol 5 3
Deane 4 2
Harold 1 1
Jerry 3 2
Janice 7 4
Cane 5 3

Total 25 15

[FDibbins]

This may just be coincidence, but y=try this...
=IF(ROUND(B3/$B$10*$D$2,0)=0,1,ROUND(B3/$B$10*$D$2,0))

[Sandyshirl]

No this didn't work. Close but not close enough. How do I load another attachment??

[oeldere]

Just the same way you attached the first one.

You can add them in another post (e.g. #5).

[Sandyshirl]

Just the same way you attached the first one.

You can add them in another post (e.g. #5).

No attachment icon available to add another attachment so I will copy it into this window.

I have eg: 14 people who have a certain amount of listings (these numbers can change). As per the formula I have under the ads/per p it is calculating how many ads the person can have determined on their total amount of listings and also determined on the total amount given between everyone. eg: 74 at the moment and the amount we have been allocated (49),. The total allocated 49 needs to equal this said amount.

Attachment now there.

[Sandyshirl]

Have attached a clearer document to enable u to understand what I need to happen. ThanksAllocations.xls

[FDibbins]

I think this is pretty much the same as this thread?
http://www.excelforum.com/excel-form...12#post3275312

I will now close this thread, as you had your question solved in the other 1. If it was not the same, please PM me and I will re-open this 1