Excel 2007: Reading data from sheet to sheet

Solved/Closed
Stephen - Apr 12, 2010 at 09:35 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 12, 2010 at 09:40 AM
I am trying to read data from sheet "a" cell to cell on sheet "b". I entered function "=sum('sheeta'!f20) in destination cell, but all I am getting is the text of the function. What am I doing wrong? Thanks for the help. Stephen

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Apr 12, 2010 at 09:40 AM
Wondering if the cell where you attempted to have the formula has been formatted to be TEXT. It should be general. Also you may have accidentally placed a ' (single quote) before the formula

By the way if you just want the value, why you need to do sum ? simply enter

='sheeta'!f20
5