want if cell containts text, then increase count by one
I want to have an If/Then statement that looks for text in a cell and then
increases a count by 1.
=If(B33="text"),("b40+1"), (""))
This is about what I have, but I want something that would read something
like:
If cell b33 contains this text, then add 1 to cell b40, if not then do
nothing.
Thanks,
Louise
|