Formula Problem?

[Iron Ax, Inc.]

I am using Excel 2000 with Windows XP.

I am having a problem. I am on Sheet 2 of my workbook.

I have SSN on a sheet named Employees in the same workbook.

I need to take the numbers on the Employees Sheet and transfer it to the
sheet 2.

I know how to do this. It just won't work.

This is a copy of my formula. =SUM(Employees!C3)

This should take the SSN that is in the C3 cell on the employees sheet and
place it at the cell where the formula is typed.

When I put this formula in the cell I am getting just a "0".

Please help.

 

[Niek Otten]

=Employees!C3

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I am using Excel 2000 with Windows XP.
|
| I am having a problem. I am on Sheet 2 of my workbook.
|
| I have SSN on a sheet named Employees in the same workbook.
|
| I need to take the numbers on the Employees Sheet and transfer it to the
| sheet 2.
|
| I know how to do this. It just won't work.
|
| This is a copy of my formula. =SUM(Employees!C3)
|
| This should take the SSN that is in the C3 cell on the employees sheet and
| place it at the cell where the formula is typed.
|
| When I put this formula in the cell I am getting just a "0".
|
| Please help.
|
|

 

[Gord Dibben]

Drop the SUM......all you want is to return the numbers, not Sum them.

=Employees!C3

Drag/copy down the column.


Gord Dibben MS Excel MVP