Countifs formula for distinct values
Hi! I need a formula that counts rows based on multiple criteria but only provides one response per duplicated value.
For Example I want a countif formula to pull one number that looks at if "Owner Name" = "Amtrack" and "Crossing Agreement Status" = "Owner Contacted" to provide only one number, but note that there are 5 rows that have Amtrack as the owner and the agreement status is always the same for all 5 rows. So this number should push out the value of 1.
Help Article Resources
Check out the Formula Handbook template!