Count records filtered by two fields

[william_denholm]

Hello,

Trying to do a count of records where the type is 'Order' and the status is 'Accepted'

Data in the format below

Number	Order	Status
1	ORD	Accepted
2	ORD	Rejected
3	MESSAGE	Accepted
4	ORD	Accepted

So I'm expecting the count of Accepted ORD to be 2.

I've tried to COUNT(IF(Order = 'ORD' AND Status = 'Accepted', Order)) but this doesnt seem to work.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Try count({<Order={'ORD'},Status={'Accepted'}>}Number)

But the expression you posted works fine with the data you posted too. Make sure to use the exact case sensitive file names.

[sunny_talwar]

Try this:

=Count({<Order = {'ORD'}, Status = {'Accepted'}>}Order)

[william_denholm]

Thank you!