Count if

[#1]

Hi,

I want to count the column "workerid" where the field isapplies='appliead' else i want to show the value  "0"

i have the table:

WorkerID	IsApplied	Applied Job Count	the result I want
4202	Applied	2	2
24875	Not Applied	1	0
8796	Not Applied	1	0
8745	Not Applied	1	0

i have the folowing formula

count({<IsApplied-= {"=if((Not Applied"}>} WorkerID_WorkerDetails)

Which shows the result shown in the column "Applied Job Count" in the table above

Thanks in advance

[#2]

Thank you all !!

[prma7799]