Referencing text in merged cells

[Woofaloo]

I have a workbook with several sheets. One of the sheets is a "recap" sheet
reflecting specific cells from all the other sheets in the workbook. I am
using " + " and then go to the specific sheet and cell I want to reference
from (all text from merged cells) I get an error or the actual formula in
the cell. I have tried to format the cells all different ways to no avail.
This is just not working on this specific recap sheet. If I try to do this
on the same sheet the referenced cells are, it works fine.

HELP!!

 

[T. Valko]

I get an error or the actual formula in the cell.

When referencing merged cells, reference the *top left* cell. For example,
if G2:H6 are merged cells then use: =G2.

If the actual formula is showing in the cell then the cell is probably
formatted as TEXT. Change the format to General then re-enter the formula.