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
Sort By: 

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.