upsidedownpw
Fri May 09 09:43:02 CDT 2008
Thanks to both of you. A conditional average wont work because I have some
values of zero that I want to include. Its just the data thats not been
input into the parent sheet that I dont want included.
One question though, whats the difference between be using the $ and not?
"Max" wrote:
> One option is to use this kind of link formula:
> =IF(Sheet2!A1="","",Sheet2!A1)
> which will return null strings (text) for any blank cells
> (Average will ignore text)
>
> Or, as-is (ie with the zeros),
> you could use a conditional average,
> eg: =AVERAGE(IF(B1:B7>0,B1:B7))
> which has to be array-entered (press CTRL+SHIFT+ENTER)
> --
> Max
> Singapore
>
http://savefile.com/projects/236895
> xdemechanik
> ---
> "upsidedown_pw" wrote:
> > I have a parent spreadsheet in tab 1 and on seperate tabs I have chunks of
> > the information through paste special and paste link. When the parent cell
> > is empty, the paste link command is putting a zero in instead of leaving it
> > blank. This is messing up my averages. I have tried changing the category
> > in format cells but this has no effect.
> >
> > I anyone knows the answer it'd be much appreciated :)