One way to play with ..

Click Tools Options Calculation tab

Check "Iteration"
Input a "1" in the "Max iterations" and "Max change" boxes

Click OK

Now put in B40: =IF(TRIM(B33)="text",B40+1,B40)

See also JE's notes and caveats at :
http://www.mcgimpsey.com/excel/accumulator.html

Look for:
- Single cell accumulator
- Worksheet Function Accumulator (using Circular References)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"lsundae" wrote in message
...
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