COUNT IF two conditions

[keithericparsons77]

Good morning, I am having trouble writing a formula for a "Count if" of 2 conditions.

I have 2 columns of data, one with a [Shop Code], one with [Check Type].

I am trying to write a formula like:

  "if [shop code] = '84100',  and  [check type] = 'accept',  count 'accept' of '84100'.

[GaryGiles · Accepted solution]

You want to use set analysis, like this:

count({$<[shop code]={'84100'},[check type]={'accept'}>} [shop code])

Not sure if there is another field you want to use as the count field.  I just used [shop code] as an example.

[keithericparsons77]

thanks for the help.  Much appreciated.  this worked.

kp