Linking formulas

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Hi,

I am hoping someone can help me with a link problem I am
trying to reference another worksheet (named "Data") to
the sheet called "Report". The cell I am linking to on
the Data sheet contains the formula:
="Average age is "&TEXT(AVERAGE(G3:G362),"0.00")
I have no problem linking it to the Report worksheet,
however I just want to show the what the average age is
(the actual number) in the Report cell, not the text.

I am using the formula =DATA!G363 to link back

Can anyone help?
 
I maybe misunderstanding, but I think you want the number only, without the
text?

=AVERAGE(DATA!G3:G362)

Seems too easy.. in that case please clarify..
 
Rebecca,

1) In DATA!G364, put the formula:

=AVERAGE(G3:G362)

and link to that cell instead of cell G363.

2) Simply use the formula:

=AVERAGE(DATA!G3:G362)

instead of the link.

3) Replace the offending text:

=SUBSTITUTE(DATA!G363,"Average age is ","")

HTH,
Bernie
MS Excel MVP
 
Thanks Frank, and that would work, however, there will be
more data entered in additional rows that will effect the
total average, so will the formula you suggested
automatically update itself as the data continues past
cell 363?
 
Try...
=AVERAGE(Data!G3:G362),"0.00")
Just recompute but reference the source sheet explicitly.
Hope this helps.
 
Thanks alot!
-----Original Message-----
I maybe misunderstanding, but I think you want the number only, without the
text?

=AVERAGE(DATA!G3:G362)

Seems too easy.. in that case please clarify..





.
Click to expand...
 
Hi
why not use a larger range?
like
=AVERAGE('data'!G3:G1000)

AVERAGE will ignore empty cells
 
Back
Top