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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am quite new the this so can any one help me,
I have set up a spreadsheet on numbers and am trying to set up when clicking on a tick box is there any way that it can automatically deduct the value from a running balance ?
really hope that I have worded this correctly !!
Many thanks
Michael
MacBook Air 13″, macOS 10.15
Hi bfd'
Here's a sample table and formula from a similar question withing the past week or so.
Rows 10 and 11 have been set as "Footer rows".
B10 contains the formula SUM(B) which sums the total bills in the column.
B11 contains the formula shown below the table, which subtracts the paid (checked) bills from that total.
Replace B10 in that formula with SUM(B) if yu do not need or want a cell showing that total.
Regards,
Barry
Hi bfd'
Here's a sample table and formula from a similar question withing the past week or so.
Rows 10 and 11 have been set as "Footer rows".
B10 contains the formula SUM(B) which sums the total bills in the column.
B11 contains the formula shown below the table, which subtracts the paid (checked) bills from that total.
Replace B10 in that formula with SUM(B) if yu do not need or want a cell showing that total.
Regards,
Barry
Thanks Barry,
I really appreciate your help with this issue;
Honestly I know nothing about how spreadsheets work etc and ended up just copying your formula haha
Do you know of a Dummies guide to numbers any where or any other info that could help me
thanks again Barry
Regards.
What does your table look like? Can you post a screenshot?
You likely will to use SUMIF, in a way similar to what you see in the 'Checklist Total' template at File > New in your menu.
SG
how to make a tick deduct an amount on numbers
