Using Excel 2002 - I have a workbook with a summary page and I link the
totals from the other worksheets *numbered purchase orders and wanted the
summary to show just the totals - Net, Tax, Total. When i link these from the
summary to the individual worksheets i keep getting #VALUE! - the forumla i
am using in the purchase order worksheets is SUM is this the wrong formula to
be using. Any advice would be appreciated.

THanks,

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link the
totals from the other worksheets *numbered purchase orders and wanted the
summary to show just the totals - Net, Tax, Total. When i link these from
the
summary to the individual worksheets i keep getting #VALUE! - the forumla
i
am using in the purchase order worksheets is SUM is this the wrong formula
to
be using. Any advice would be appreciated.

THanks,

The foruma i am using in the purchase order spreadsheets is eg: =SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it to this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link the
totals from the other worksheets *numbered purchase orders and wanted the
summary to show just the totals - Net, Tax, Total. When i link these from
the
summary to the individual worksheets i keep getting #VALUE! - the forumla
i
am using in the purchase order worksheets is SUM is this the wrong formula
to
be using. Any advice would be appreciated.

THanks,

Hi!

If this formula:

=SUM(G23:G25)

is on Sheet2 in cell A1 and retunrs a valid result, then:

=Sheet2!A1

should also return the same valid result.

When you say "linking", what exactly does that mean?

=Sheet2!A1 is considered a link.

Biff

"KAT" wrote in message
...
The foruma i am using in the purchase order spreadsheets is eg:
=SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it to
this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link the
totals from the other worksheets *numbered purchase orders and wanted
the
summary to show just the totals - Net, Tax, Total. When i link these
from
the
summary to the individual worksheets i keep getting #VALUE! - the
forumla
i
am using in the purchase order worksheets is SUM is this the wrong
formula
to
be using. Any advice would be appreciated.

THanks,

Hi Biff,

Apologies i copied the actual formula from sheet 2 (named 00217) not the
formula that is showing up when i link sheet 2 to sheet 1 (called
the summary) the formula that is showing up in the linked (destination)
sheet is ='00217'!G23:G25 and that is where i keep getting the #VALUE!

When i say "linking" i mean in the destination cell (where i want the
info) i type = then i go to the cell in the other worksheet that has /
or will have the required info then press enter and the link is made.
I have not had this problem before and am confused as to how to fix it..
would it be easier if i attached the spreadsheet?

Thanks for you help.

KAT

Biff wrote:
Hi!

If this formula:

=SUM(G23:G25)

is on Sheet2 in cell A1 and retunrs a valid result, then:

=Sheet2!A1

should also return the same valid result.

When you say "linking", what exactly does that mean?

=Sheet2!A1 is considered a link.

Biff

"KAT" wrote in message
...
The foruma i am using in the purchase order spreadsheets is eg:
=SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it to
this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link the
totals from the other worksheets *numbered purchase orders and wanted
the
summary to show just the totals - Net, Tax, Total. When i link these
from
the
summary to the individual worksheets i keep getting #VALUE! - the
forumla
i
am using in the purchase order worksheets is SUM is this the wrong
formula
to
be using. Any advice would be appreciated.

THanks,

OK.........

='00217'!G23:G25

That's where you're getting the error. You're referencing a range of cells,
not a single cell.

If you want the sum of those cells:

=SUM('00217'!G23:G25)

If you want each individual value in its own cell: (vertically)

='00217'!G23

Copy down to get:

='00217'!G24
='00217'!G25

OR, select 3 cells then enter as an array: (vertical)

='00217'!G23:G25

Biff

"KAT" wrote in message
...
Hi Biff,

Apologies i copied the actual formula from sheet 2 (named 00217) not the
formula that is showing up when i link sheet 2 to sheet 1 (called the
summary) the formula that is showing up in the linked (destination) sheet
is ='00217'!G23:G25 and that is where i keep getting the #VALUE!

When i say "linking" i mean in the destination cell (where i want the
info) i type = then i go to the cell in the other worksheet that has / or
will have the required info then press enter and the link is made.
I have not had this problem before and am confused as to how to fix it..
would it be easier if i attached the spreadsheet?

Thanks for you help.

KAT

Biff wrote:
Hi!

If this formula:

=SUM(G23:G25)

is on Sheet2 in cell A1 and retunrs a valid result, then:

=Sheet2!A1

should also return the same valid result.

When you say "linking", what exactly does that mean?

=Sheet2!A1 is considered a link.

Biff

"KAT" wrote in message
...
The foruma i am using in the purchase order spreadsheets is eg:
=SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it to
this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link
the
totals from the other worksheets *numbered purchase orders and wanted
the
summary to show just the totals - Net, Tax, Total. When i link these
from
the
summary to the individual worksheets i keep getting #VALUE! - the
forumla
i
am using in the purchase order worksheets is SUM is this the wrong
formula
to
be using. Any advice would be appreciated.

THanks,

Hi Biff,

I have solved it - the source cell was a merged cell and the merge was
compromising the link process. Thanks for your help.

KAT

"Biff" wrote:

Hi!

If this formula:

=SUM(G23:G25)

is on Sheet2 in cell A1 and retunrs a valid result, then:

=Sheet2!A1

should also return the same valid result.

When you say "linking", what exactly does that mean?

=Sheet2!A1 is considered a link.

Biff

"KAT" wrote in message
...
The foruma i am using in the purchase order spreadsheets is eg:
=SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it to
this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link the
totals from the other worksheets *numbered purchase orders and wanted
the
summary to show just the totals - Net, Tax, Total. When i link these
from
the
summary to the individual worksheets i keep getting #VALUE! - the
forumla
i
am using in the purchase order worksheets is SUM is this the wrong
formula
to
be using. Any advice would be appreciated.

THanks,

Ah ha!

Those merged cells are more trouble than they're worth!

Biff

"KAT" wrote in message
...
Hi Biff,

I have solved it - the source cell was a merged cell and the merge was
compromising the link process. Thanks for your help.

KAT

"Biff" wrote:

Hi!

If this formula:

=SUM(G23:G25)

is on Sheet2 in cell A1 and retunrs a valid result, then:

=Sheet2!A1

should also return the same valid result.

When you say "linking", what exactly does that mean?

=Sheet2!A1 is considered a link.

Biff

"KAT" wrote in message
...
The foruma i am using in the purchase order spreadsheets is eg:
=SUM(G23:G25)
for the totals column and when i go from the summary sheet to link it
to
this
total cell it comes up with the value error.

Thanks
Kat

"Biff" wrote:

Hi!

Post the complete formula that you're using.

Biff

"KAT" wrote in message
...
Using Excel 2002 - I have a workbook with a summary page and I link
the
totals from the other worksheets *numbered purchase orders and
wanted
the
summary to show just the totals - Net, Tax, Total. When i link these
from
the
summary to the individual worksheets i keep getting #VALUE! - the
forumla
i
am using in the purchase order worksheets is SUM is this the wrong
formula
to
be using. Any advice would be appreciated.

THanks,