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 for pop menu in numbers.

im trying to add a formula to a pop menu option for. budget my wife and I are doing. ill try and explain it as best as I can but basically the "Which Paycheck" column in table 1 has a pop menu in each cell that will allow me to chose which paycheck that item is coming out of but I want the amount from the table 2 columns to go down as we enter which paycheck each item will be designated too I know there are apps for this and that I can just download it but I really want to get better at doing it myself and I want to learn numbers. so basically as an example, the first thing would be sam tithe. we would want to take that out of paycheck S2 so the $350 would be taken out of S2 for Sam missions we would want to take that out of S1 so it would be $225 removed from the amount in S1 and so on and so on.

Posted on Jan 15, 2021 8:49 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 15, 2021 11:29 PM

Maybe something like this?



In C2 of Table 2, filled down:


=SUMIF(Table 1::$C,$A2,Table 1::$B)


In D2, filled down:


=B2−C2


The Pop-Up menu in the cells in column C of Table 1 look like this:




Set up in the panel at the right like this:




SG

Similar questions

1 reply

Formula for pop menu in numbers.

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