how to make an IF statement for multiple checkboxes

hi! thanks in advance for y'all's help!

i'm trying to make an if statement for multiple checkboxes and i want to return "yes" if ONE of the checkboxes is true, otherwise "no".

i'm using this to keep track of collectibles in a video game. the collectibles are tracked through each character you play as, so it doesn't matter who collects it. i want to be able to tick off who collected what and have the "total" column automatically tell me whether or not at least one character collected this item, if that makes sense.

if i try the formula: IF(C2:E2,"yes","no"), i get the message "the range C2:E2 can't be used as a single value." but i don't understand why. i've also tried doing separate IF statements for each cell and combining them and that doesn't work either.

i made an example (the "total" column is what i WANT it to say. any time i try a formula i get an error for using multiple checkboxes):