Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Formula to divide a total dollar amount into numerous cells

I am trying to figure out how I can use a total dollar amount in a cell and split that total of the cell into a group of cells on the same column.



example: divide the total dollar amount in cell: D19 and the split that amount total into cells : D-2 to D-17


up until now I’ve been doing it manually and inputting the amounts as in the picture. However, I was looking for more easier way of just splitting that amount through a formula of some sort, but don’t know how to

Windows, 10

Posted on Aug 31, 2022 2:50 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 31, 2022 4:34 PM

Something like

=D19÷ROWS($A2:$A17)


But if the checkboxes in A are to indicate the players who are included in the allocation,

=D19÷COUNTIF($A2:$A17, TRUE)


1 reply

Formula to divide a total dollar amount into numerous cells

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.