Hi all. I'm new to this board and have found a lot of useful info. I've
tried copying some of the examples, but it's just not working for me.
I'm trying to do forecasts and I'm having a problem trying to figure
out how to link two worksheets and then have a formula in the same
cell.

Example: 2006!A21 =34567

After linking to the 2nd s/s, I need to have a formula to calculate a
10 week average which is the basic formula of =AVERAGE(A11:A20)

I've tried =(AVERAGE(A11:A20)&''2006!A21") but that only gave me the
average + plus the amount in 2006!A21. If I put SUM in front, then I
get a VALUE# error message.

The link would be to 2007!B21

The cell reference would also need to be adjusted to fill in weekly.

I hope this is clear enough.
TIA
Loretta

The easiest way to select cells for use in formulas, at least until you're
familiar with the syntax is to click on the cell you want to reference. For
instance, enter the function =average( then click on the range of cells. I
think you want =average('2006'!a11:a20). If you want to include multiple
cells (or multiple ranges) in the formula, click and drag to select the first
range, then type a comma, then click and drag to select the next range, and
so on: =average(a11:a20,'2006'!a21).
HTH. --Bruce

" wrote:

Hi all. I'm new to this board and have found a lot of useful info. I've
tried copying some of the examples, but it's just not working for me.
I'm trying to do forecasts and I'm having a problem trying to figure
out how to link two worksheets and then have a formula in the same
cell.

Example: 2006!A21 =34567

After linking to the 2nd s/s, I need to have a formula to calculate a
10 week average which is the basic formula of =AVERAGE(A11:A20)

I've tried =(AVERAGE(A11:A20)&''2006!A21") but that only gave me the
average + plus the amount in 2006!A21. If I put SUM in front, then I
get a VALUE# error message.

The link would be to 2007!B21

The cell reference would also need to be adjusted to fill in weekly.

I hope this is clear enough.
TIA
Loretta