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 - 05 Jan 2007 20:25 GMT
=Employees!C3

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| I am using Excel 2000 with Windows XP.
|
[quoted text clipped - 15 lines]
|
| Please help.
Gord Dibben - 05 Jan 2007 20:36 GMT
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
>I am using Excel 2000 with Windows XP.
>
[quoted text clipped - 15 lines]
>
>Please help.