Forum Discussion

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)

Formulas and Functions

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!!!

Steel Contributor

Aug 25, 2020

You need to change the syntax

SUMIF(X2:X30,"<>"&CLSD,AI2-S2)

I am not sure what you have in each cell though.

Cheers

31moons
Copper Contributor
Aug 25, 2020
wumolad

Cells X2:X30 contain text
Cells A12 and S2 contain currency

I try to minus two cells only if the other cell contains "CLSD"

I tried your suggestion but it did not work.
- wumolad
  Steel Contributor
  Aug 25, 2020
  31moons
  
  Are the contents of the cells just CLSD or something else?
  
  Or is it possible to have CLSD and other texts in the same cell?
  
  Cheers
  - 31moons
    Copper Contributor
    Aug 25, 2020
    wumolad There is no other content than CLSD in the cell.