Formula to calculate the percentage of occurrences in a range of cells w/ 2 criteria

Jenny C Marrero

Good afternoon!

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!

Paul McGuinness

Hi @Jenny C Marrero

You pretty much had it,

This formula works just need to adjust for your column names

=SUM(COUNTIF([Column52]@row:[Column55]@row, ="Green"), COUNTIF([Column52]@row:[Column55]@row, ="Yellow")) / COUNT([Column52]@row:[Column55]@row)

Hope it helps, Thanks

Paul

Jenny C Marrero

Perfect! Thank you so very much @Paul McGuinness! I knew I was close, but couldn't see my error. Very grateful for the help!!

Jenny C Marrero

Paul McGuinness

Hi @Jenny C Marrero

You pretty much had it,

This formula works just need to adjust for your column names

=SUM(COUNTIF([Column52]@row:[Column55]@row, ="Green"), COUNTIF([Column52]@row:[Column55]@row, ="Yellow")) / COUNT([Column52]@row:[Column55]@row)

Hope it helps, Thanks

Paul

Jenny C Marrero

Perfect! Thank you so very much @Paul McGuinness! I knew I was close, but couldn't see my error. Very grateful for the help!!