shorten IF Statements

  • Thread starter Thread starter Flanno
  • Start date Start date
F

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!
 
=SUM(Y9:INDEX(O9:Y9,12-W22))

--
---
HTH

Bob


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