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
|