Replicate CountIF

[hemant86]

Hi Team,

I'm trying to implement countIF like in excel. I have attached the sample input file. Column F contains the complete formula I would like to implement.

Basically I'm struggling with the Count IF part which I have separately mentioned in Column H. The Output of the countif part should be as mentioned in Column H.

Appreciate any help.

[MatthewO]

Hi @hemant86 : I believe the expression below will achieve the result you want. You could use this in a Formula tool to create the calculated column.

IF [Alterix ID] = "A2" AND [Payment Credited] = "Yes" AND [Payment re-processing] = "Yes" THEN 1 ELSE 0 ENDIF

[atcodedog05 · Accepted solution]

Hi @hemant86 

You can acheive this by doing something like this.

Hope this helps : )

[hemant86]

Thanks for your response @MatthewO . Actually my requirement is little different. The one you are suggesting will give 1 only in case of "A2YesYes".

But I need it to be 1 for all possible combination with A2 like "A2NoYes" or A2"NoNo". Here the idea is to find if the last credited status for an employee is Yes then all the entries for that employee can be eliminated. 

[hemant86]

Thanks @atcodedog05 . This looks like will do the job for me. Let me try it out. Thanks Again🙂