| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed for dividing hours by numbers | Excel Discussion (Misc queries) | |||
| DIVIDING TOTAL CELLS IN COLUMN BY 16 TRYING TO CHANGE WEIGHT OZ TO | Excel Worksheet Functions | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| Dividing a Total with criteria... | Excel Discussion (Misc queries) | |||
| What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
Linear Mode
