View Single Post
  #1   Report Post  
lsundae
 
Posts: n/a
Default 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