incrementing value if "if" condition satisfied

[priyanka.R]

Hi,

Pls help in getting a output.Each time if the "if" condition satisfies the counter should increment one value .So that i need to get the value and pass it some where.

if value= "hi" then
'counter should have value 1
end if

 

[JackDanIce]

Is this part of some VBA code? Can you post your code? I think what you need is:

Dim IfCounter as Integer
If value = "hi" Then
  IfCounter = IfCounter + 1
End If

Your example below doesn't say what value is attached to - i.e. what object you're testing for the string "hi"

 

[Cease]

Also, in case you're just going for straight formulas, you can use Countif.

If the column you're looking for "Hi" as the result was column A:

=countif(A1:A300,"Hi")


Hope it helps :D

 

[Scott Huish]

Note I wouldn't use value as a variable name as it is a VBA keyword, but:

Sub test()
Dim lCounter As Long
lCounter = lCounter - (Value = "hi")
End Sub

 

[priyanka.R]

Hi,

Thanks a lot i got the expected one.

Is this part of some VBA code? Can you post your code? I think what you need is:

Dim IfCounter as Integer
If value = "hi" Then
  IfCounter = IfCounter + 1
End If

Your example below doesn't say what value is attached to - i.e. what object you're testing for the string "hi"