Conditional counts in array

[jlk3]

How to tally counts in an table as below across 2 columns, please. Simplified worksheet below.

For each 'payor', I want to be able to count the number of each 'order type'.

Something to the effect of: COUNTIF (payor="GR" AND order_type="P")

There are only 2 payor values and 2 order type values, so I'm thinking I would create 4 formulas which specify the 4 possible combos.

Any help would be appreciated. Thank you!

[TABLE="width: 200, align: left"]
<tbody>[TR]
[TD]Order_type[/TD]
[TD]Payor[/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]GR[/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]GR[/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]GR[/TD]
[/TR]
[TR]
[TD]s[/TD]
[TD]GR[/TD]
[/TR]
[TR]
[TD]s[/TD]
[TD]GR[/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]JK[/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]JK[/TD]
[/TR]
[TR]
[TD]s[/TD]
[TD]JK[/TD]
[/TR]
[TR]
[TD]s[/TD]
[TD]JK[/TD]
[/TR]
[TR]
[TD]s[/TD]
[TD]JK[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

What is the expected count for GR?

 

[jlk3]

Meaning how many rows in the worksheet? It is not very large. I need to do in two worksheets. One sheet has about 200 rows. The other about 500.

 

[Aladin Akyurek]

Meaning how many rows in the worksheet? It is not very large. I need to do in two worksheets. One sheet has about 200 rows. The other about 500.

What is the count you expect for the sample you posted?

 

[jlk3]

Oh...

GP where order_type="P": 3
GP where order_type="S": 2
JK where order_type="P": 2
JK where order_type="P": 3

Is that what you mean?

Thank you.

 

[Aladin Akyurek]

Oh...

GP where order_type="P": 3
GP where order_type="S": 2
JK where order_type="P": 2
JK where order_type="P": 3

Is that what you mean?

Thank you.

Try...

=COUNTIFS(A:A,"p",B:B,"GR")

 

[jlk3]

Yes! That did it. Thank you.

Just needed "=" signs in the formula. =COUNTIFS($I$7:$I215,"=P",$K$7:$K215,"=JK")

You've been super helpful. And super fast. Thank you very much.

 

[Aladin Akyurek]

Yes! That did it. Thank you.

Just needed "=" signs in the formula. =COUNTIFS($I$7:$I215,"=P",$K$7:$K215,"=JK")

You've been super helpful. And super fast. Thank you very much.

You are welcome. By the way, when no relational operator is specified, Excel assumes the equalty operator, i.e. '=', per default.

 

[jlk3]

oh, good to know. thanks.

i gave that a try and it does work as you say.

i guess the problem i had was due to another error I had made then.

thanks again.