Referencing text in merged cells

W

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

equals merged cells 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Wrapping Text in Merged Cells 4
using the =page! feature to transpose a row to column 0
How to count merged cells 1
Excel, assign cells in multiple worksheets from one sheet 1
Update cell value based on name and specific date 1
Sharing workbooks limitations - Merged Cells 12

Top