Apple Intelligence is now available on iPhone, iPad, and Mac!

numbers formula

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

Posted on Oct 13, 2024 9:36 AM

Reply
1 reply

numbers formula

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