Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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.