Hi,

I've created lists with multiple possible answers e.g. types of exercise carried out - running, cycling, none
I want to calculate the percentage of people that are exercising overall, regardless of which type. I know I could just do the percentage of people that said "none" by doing: =COUNTIF(b2:b60, "none")/COUNTA(b2:b60) and do it backwards from there but I want my work to look more neat.
How do I add multiple options? I tried =COUNTIF(b2:b60, "cycling", "running")/COUNTA(b2:b60) but it doesn't work

I'd appreciate any help, thank you!