Excel help. Dividing a number equally between x number of cells.

Soldato
Joined
16 May 2004
Posts
7,164
Location
Derby
Ok I have £1000 and would like evenly split it between a number of cells/list.
For example, I have ten people in a list who will receive £100 each. I want it so the £1000 can be changed to whatever amount i need and it fills in the list of people share equally.
£1000 < so when this changes the 4 cells below (the money ones) change accordingly.
dave £100
john £100
sue £100
steve £100

Get what I mean? Im not great with excel so I do need help.
 
BTW, just be aware of absolute cell references.

The formula provided above by @HecFam is what I would use if you had a changing list of people.

However make sure you absolute the cell with the amount to be split, i.e. =SUM($C$1)/COUNTA(A:A)

There are 40 people. Names in column A with column B being where I want the amount filled with an even amount. I copied and pasted you formula (changed the cells to reflect mine and it juts listed 0 in all cells next to names
 
Back
Top Bottom