Formula error in merged cells

  • Thread starter Thread starter librarynut
  • Start date Start date
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.
 
Hi,

Pls chech the name ref. of merge cell in the name box, it may be not the
part of your sum array.
 
You must log in or register to reply here.

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

Wrapping Text in Merged Cells 4
Sharing workbooks limitations - Merged Cells 12
Windows 7 Autofit row heights of merged cells in protected worksheet 0
merge and center not merging and centering 6
Counting Merged Cells 6
Link to external worksheet merged cell returns a #VALUE 1
Merged cells disturb autofilter indicator 2
Locate merged cells to sort on 3 columns 2

Back
Top