I need help with a formula in my Summary Sheet
This is what I have:
=SUM(COLLECT([Country Count]:[Country Count], [Location Status]:[Location Status], "Active"), COLLECT([Country Count]:[Country Count], [Location Status]:[Location Status], "Operational"))
Because we have work in several locations of a country, I only need to count the country once. I have that formula in place.
But there are 2 Location Status choices that I want to collect the sum of. One choice is "Active" and the other choice is "Operational". So if there are 3 active locations and 2 operational locations, I want the sum to show 5.
Thank you for ANY help!
Help Article Resources
Check out the Formula Handbook template!