Counting row depending on 2 criteria

Options

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!