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

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

Hi
this is not really possible with formulas. you'll need VBA for this or a
helper cell

"lsundae" wrote:

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

=IF(B33="text",B40+1,B40)


.. enter <text in B33 and 5 in B40
if this is so the cell where you enter the above will be 6
if this not so the cell will be 5
is this what you want

Frank Kabel wrote in message
...
Hi
this is not really possible with formulas. you'll need VBA for this or a
helper cell

"lsundae" wrote:

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

"Frank Kabel" wrote
....
this is not really possible with formulas.

Thought the example suggested earlier using a formula in *B40* itself
(with the iteration settings) seems to work ok under light testing ..
of course, within bounds of the caveats mentioned in JE's:
http://www.mcgimpsey.com/excel/accumulator.html
Worksheet Function Accumulator (using Circular References)

--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---