COUNT over several sheets...Part 2!

[Fybo]

Thanks for all your help guys...and quick!!

I've tried =SUM(January 2005:December 2005!D34) but the cell just displays
the function and not the result. Is the function wrong or am I missing
something.

Have I got all the spaces and characters correct?

Is it possible that because there are no values in the later sheets (ie
September 2005, Cell D34 will be blank) that the function isn't working?

Thanks again, Fybo.

[JulieD]

Hi

answered in the original thread ...

Cheers
JulieD

"Fybo" <[email protected]> wrote in message
news:[email protected]...
> Thanks for all your help guys...and quick!!
>
> I've tried =SUM(January 2005:December 2005!D34) but the cell just displays
> the function and not the result. Is the function wrong or am I missing
> something.
>
> Have I got all the spaces and characters correct?
>
> Is it possible that because there are no values in the later sheets (ie
> September 2005, Cell D34 will be blank) that the function isn't working?
>
> Thanks again, Fybo.
>

[Fybo]

Thanks...git it! Much Appreciated

Fybo

"JulieD" wrote:

> Hi
>
> answered in the original thread ...
>
> Cheers
> JulieD
>
> "Fybo" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks for all your help guys...and quick!!
> >
> > I've tried =SUM(January 2005:December 2005!D34) but the cell just displays
> > the function and not the result. Is the function wrong or am I missing
> > something.
> >
> > Have I got all the spaces and characters correct?
> >
> > Is it possible that because there are no values in the later sheets (ie
> > September 2005, Cell D34 will be blank) that the function isn't working?
> >
> > Thanks again, Fybo.
> >
>
>
>