Forum Discussion
How to split a % total cell between a varying number of cells
I want to have a total cell in an Excel spreadsheet which adds up the percentages in a number of other cells to 100%. There may be eg - 4 other cells selected in which case they will be 25% each....
Hey - you can forget this. I've worked out what to do - divide what's in the total cell by the number of cells and then copy the answer into each cell. It works. Thanks.