Formula error in merged cells
 

Help! I recently discovered an error in my shipping worksheet. I
sometimes need to merge certain cells when I am combining items from
different purchase orders into the same shipment. However, when I
totaled the column (SUM) containing the merged cells, it delivers a
wrong answer.


I have been using this feature for about 6 months, and this is the
first time it did this. Any ideas why the error?


I cannot attach the excel file and saving as a text file takes out the
merged cells.


--
librarynut
------------------------------------------------------------------------
librarynut's Profile: http://www.excelforum.com/member.php...fo&userid=7149
View this thread: http://www.excelforum.com/showthread...hreadid=467773

Hi,

Pls chech the name ref. of merge cell in the name box, it may be not the
part of your sum array.

"librarynut" wrote:


Help! I recently discovered an error in my shipping worksheet. I
sometimes need to merge certain cells when I am combining items from
different purchase orders into the same shipment. However, when I
totaled the column (SUM) containing the merged cells, it delivers a
wrong answer.


I have been using this feature for about 6 months, and this is the
first time it did this. Any ideas why the error?


I cannot attach the excel file and saving as a text file takes out the
merged cells.


--
librarynut
------------------------------------------------------------------------
librarynut's Profile: http://www.excelforum.com/member.php...fo&userid=7149
View this thread: http://www.excelforum.com/showthread...hreadid=467773