shorten IF Statements

[Flanno]

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:y9),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!

 

[bpeltzer]

=sum(offset(y9,1-w22,0,w22,1))

 

[Bob Phillips]

=SUM(Y9:INDEX(O9:Y9,12-W22))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Flanno]

TY! Perfect!

=SUM(Y9:INDEX(O9:Y9,12-W22))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)