Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
=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 |
#5
![]() |
|||
|
|||
![]()
"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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |