Count one site pending circuit
I need a formula to count how many sites still have one circuit to be completed
There are two columns "1st Circuit Status and 2nd Circuit Status"
If one cell has "Circuit Delivered" and another cell has "anything else beside "Circuit delivered or a blank cell" counts one site
If two cells have "Circuit Delivered" they don't count
if both cells from both columns have "N/A", it doesn't count
If both cells from both columns have "canceled" doesn't count
If one cell from one column has either "N/A" or "Cancelled" and another cell from the other column has anything besides "Circuit Delivered" counts one site
if both columns have a "blank" cell, it counts one site
It only counts 1 site if any cell from "1st Circuit Status and 2nd Circuit Status" has anything else besides "Circuit Delivered"
Thank for your help very much! 😀
Help Article Resources
Check out the Formula Handbook template!