Count If One field is Equal to Another Field

[Anonymous]

Hello,

I am having trouble with my formula. I want the expression to only count the names that equal eachother in two fields.

Here is what I have:

=Count(if([Queried Provider]=[Responding Provider])

If anyone could give me advice it would be appreciated!

Thanks,

Erin

[sunny_talwar · Accepted solution]

May be this

-Count([Queried Provider]=[Responding Provider])

or this

Sum(If([Queried Provider]=[Responding Provider], 1, 0)

[justinvchiang]

I think you're missing a right parenthesis and also need to complete the if logic, such as if [Queried Provider]=[Responding Provider] then n else x or

Count(if([Queried Provider]=[Responding Provider],1))

[Anonymous]

Thank you! The second expression worked!