What is the formula for dividing-I have the total
 

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

What is the formula for dividing-I have the total
 

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

On Aug 2, 1:20 am, Susan wrote:
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