Counting row depending on 2 criteria

Caroline Wittig

Hello,

I'm trying to count the entries in a column (ID) depending on 2 other columns (Name and Status) values.

I want to know how many rows there are in a file depending on a country Name and a certain status.

I have tried below 2 options but have not succeeded.

=COUNTIF({Customer Impl Action Items Log - Joint ID}, AND({Customer Impl Action Items Log - Joint Status}, "Closed", {Customer Impl Action Items Log - Joint Name} = "UK"))

=COUNTM(AND({ Impl Action Items Log - Internal NAme} = "UK", { Impl Action Items Log - Internal Status} = "Closed")) + COUNTM(AND({ Impl Action Items Log - Joint Name} = "UK", { Impl Action Items Log - Joint Status} = "Closed"))

Is there a different formula to use?

Leibel S

Try using a COUNTIFS formula

Leibel S

Try using a COUNTIFS formula

Caroline Wittig

Thank you that solved the issue.