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 obviously relatively new to spreadsheets in general and am trying to have numbers total a couple of cells if another cell has a text not equal to "Y" - I tried doing it like this but it doesn't seem to work right. SUMIF(Payment received ≠"Y",Invoice amount −'Partial Payment ') also would like it to recognize a blank cell as containing a 0 in the number part of the calculation if possible
Mac mini, macOS 12.7
It would help if you could post a screenshot but from your description I am guessing you mean something like this?
IF(D2="Y",SUM(B2:B3),"")
SG
numbers formula
