| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot view all of text in large cell, even though I have it to w. | Excel Discussion (Misc queries) | |||
| Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
| how to hyperlink text to a cell | New Users to Excel | |||
| Forcing text onto new line in cell | New Users to Excel | |||
| how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Threaded Mode
