Formula to calculate the percentage of occurrences in a range of cells w/ 2 criteria
I am trying to calculate the percentage of occurrences within a range of cells in a row that contain either the yellow or green bubble symbols. I can get it to work properly for 1 criteria (or color of bubble) but not for either of 2 colors. How do I get the below formula to divide the number of green OR yellow bubbles by all entries in the range? Would be grateful for any assistance!
Help Article Resources
Check out the Formula Handbook template!