=SUM(Sheet2:Sheet9!IV65536)-meaning of equation?

[djc]

I am trying to add the value of the last cell in the last column across
several worksheets. Can anyone explain what I can look up to learn this?
Thank you

[Toppers]

This will add the value in IV66636 for worksheets Sheet2 to Sheet9 inclusive.

HTH

"djc" wrote:

> I am trying to add the value of the last cell in the last column across
> several worksheets. Can anyone explain what I can look up to learn this?
> Thank you

[Peo Sjoblom]

My guess is that you have to use a formula on each sheet that will find the
last cell

=LOOKUP(9.99999999999999E+307,IV:IV)

will return what's in the last cell if numeric, then if you link to that on
each sheet in let's say A1 SO A1 holds that formula then you can use

=SUM(Sheet1:Sheet9!A1)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"djc" <djc@discussions.microsoft.com> wrote in message
news:DDCADC9C-E207-4300-9E44-13254B2BE429@microsoft.com...
>I am trying to add the value of the last cell in the last column across
> several worksheets. Can anyone explain what I can look up to learn this?
> Thank you