shorten IF Statements
 

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!

shorten IF Statements
 

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

"Flanno" wrote:

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!

shorten IF Statements
 

=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" wrote in message
...
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!

shorten IF Statements
 

TY! Perfect!

"Bob Phillips" wrote:

=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" wrote in message
...
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!