Help with excel formula and row referance from another cell 1

[ls62]

Hi,

I have a formula =sum('sheeta'!$b$69,'sheeta'!$e$69) and I now need to have the row ($69) change based upon the value of another cell. For example if cell 'a1' has 5 in it then the formula would evaluate to:

=sum('sheeta'!$b$5,'sheeta'!$e$5)

Every time you change the 'a1' cell it would cause the formula's to evaluate differently.

I was thinking something like:

=sum('sheeta'!$b$ & cell("contents",a1), ...)

but it doesn't seem to work.

Can this be done and how?

 

[AnotherHiggins]

Try
=SUM(Sheeta!$B$5,INDIRECT("Sheeta!$E$"&B1))

My name is John, and I approved this post.

To get the best answers fast, please read faq181-2886

 

[ls62]

anotherhiggins,

Thank you! That works great and is just what I wanted. I figured it was something like that but wasn't sure what to use or what the syntax was.

Thanks again for your quick response.

LEE

 

[AnotherHiggins]

Gald to help!

My name is John, and I approved this post.

To get the best answers fast, please read faq181-2886