A formula to count a series of "Health Status" in a column to display the status with the largest #?
This one is tricky. I'd like to be able to count the # of green, yellow, red & blue statuses in a column (lower image) display on a dashboard (upper image). The other tricky part is that I only want to count the statuses on the rows that are Level 0. Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!