Formula error in merged cells

L

librarynut

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.
 
A

Anirudh

Hi,

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