How to exclude rows that shouldn't be part of a total %?

RAU

Hello Community,

I am trying to figure out how to exclude a "checkbox" (ex. Done5) away that wouldn't be calculated as part of the total %?

Any ideas/suggestions?

Nabil Hayek

Hi RAU,

Maybe if you use conditional formatting to select for all the rows except the one you want to exclude. Then apply the formula to the remaining rows

Hope that helps