#value!

[Pipestew]

Most likely a simple solution...

I have I6 on sheet 2 set to display the value of H4:H5 (a merged cell) on sheet 1. The result is the #VALUE! error. I have this same cell relationship working properly amongst other sheets, but for some reason, I am getting this error only for this specific relationship. Sheet 1 is calculating the value of H4:H5 perfectly normal.

Any help is appreciated. Thanks.

[raehippychick]

I had this the other day and found if I referenced just the first (top left) cell in the merged cells it worked ok

e.g. in I6 just reference sheetname H4

HTH

[Pipestew]

Thanks for the advice. For whatever reason, it works perfect.

[raehippychick]

Glad it helped

I think it is beacaue when cells are merged or unmerged only the top left is taken into account by excel normally