What is the formula for dividing-I have the total

S

Susan

I have a spreadsheet for a childrens raffle. I need to divide my total
amount among the players. Example-- $5000. is my total & I want a formula
that will divide that among the kids selling as I enter their names
 
P

Pete_UK

If you enter names into column A, then COUNTA(range) will tell you how
many there are. So, if you put this formula in C2:

=5000/COUNTA(A:A)

it will tell you how much each child gets (assuming a linear
distribution).

Hope this helps.

Pete
 
Top