Can someone help me shorten the following IF statement, or give me something
simpler that will work. I have more conditions I'll need to add:


=if(w22=11,sum(o9:y9),if(w22=10,sum(p9:y9),if(w22= 9,sum(q9:y9),if(w22=8,sum(r9:y9),if(w22=7,sum(s9:y 9),if(w22=6,sum(t9:y9),if(w22=5,sum(u9:y9),if(w22= 4,sum(v9:y9),if(w22=3,sum(w9:y9)))))

I've been looking at this for so long, I can't think clearly!