I'm trying do the following and it's not working.
If cells X2:X30
This formula is not working:
View best response
You need to change the syntax
I am not sure what you have in each cell though.
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.
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?
@wumolad There is no other content than CLSD in the cell.
Depends on your needs, but to sum on entire range
it could be
@Sergei Baklan This worked too. Thank you! Thank you!
@31moons , you are welcome