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.
hi I’m trying to track how much money is outstanding to me, so if a client hasn’t paid me yet I type “no” in K3, then it takes the value of D3 and adds it K2. But if I type “yes” then it removes it from the the value of D3 from K2 therefore telling telling me how much money is outstanding
iPad mini 4, iPadOS 14
You can do something like this:
In this example rows 1 and 2 are defined as Header Rows.
The formula in K2 is: =SUMIF(K,TRUE,D)
If row 2 is not a Header Row then you would do something like this (you would need to change K3:K6 to the actual range in your table):
=SUMIF(K3:K6,TRUE,D3:D6)
If you like entering "Yes" and "No" instead of just checking a checkbox, then the formulas would be:
=SUMIF(K,"Yes",D)
or,
=SUMIF(K3:K6,"Yes",D3:D6)
SG
You can do something like this:
In this example rows 1 and 2 are defined as Header Rows.
The formula in K2 is: =SUMIF(K,TRUE,D)
If row 2 is not a Header Row then you would do something like this (you would need to change K3:K6 to the actual range in your table):
=SUMIF(K3:K6,TRUE,D3:D6)
If you like entering "Yes" and "No" instead of just checking a checkbox, then the formulas would be:
=SUMIF(K,"Yes",D)
or,
=SUMIF(K3:K6,"Yes",D3:D6)
SG
Nice idea, thanks for that
Numbers
