Forum Discussion

31moons's avatar
31moons
Copper Contributor
Aug 25, 2020
Solved

Minus cells if other cells equal

I'm trying do the following and it's not working.   If cells X2:X30   "<>CLSD"   Then AI2-S2   This formula is not working: =SUMIF(X2:X30,"<>CLSD",AI2-S2)
Excel on Mac
Formulas and Functions
  • 31moons's avatar
    31moons
    Aug 25, 2020

    31moons 

    I got it! Instead of doing a range of cells. I focused on one cell and used the IF function.
    IF(X2="CLSD",AI2-S2,0)
    Thank you everyone!!!
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 25, 2020

31moons 

Depends on your needs, but to sum on entire range

it could be

=SUMPRODUCT((X2:X30="CLSD")*(AI2:AI30-S2:S30))
31moons's avatar
31moons
Copper Contributor
Aug 26, 2020

SergeiBaklan This worked too.  Thank you! Thank you!