L
librarynut
Help! I recently discovered an error in my shipping worksheet.
sometimes need to merge certain cells when I am combining items fro
different purchase orders into the same shipment. However, when
totaled the column (SUM) containing the merged cells, it delivers
wrong answer.
Specifically column F and column H that contain the merged cells don'
add up correctly. Column F is +1 more than it should be. Column H i
+125 more than it should be.
I have been using this feature for about 6 months, and this is th
first time it did this. Any ideas why the error
+-------------------------------------------------------------------
|Filename: Sample book.txt
|Download: http://www.excelforum.com/attachment.php?postid=3812
+-------------------------------------------------------------------
sometimes need to merge certain cells when I am combining items fro
different purchase orders into the same shipment. However, when
totaled the column (SUM) containing the merged cells, it delivers
wrong answer.
Specifically column F and column H that contain the merged cells don'
add up correctly. Column F is +1 more than it should be. Column H i
+125 more than it should be.
I have been using this feature for about 6 months, and this is th
first time it did this. Any ideas why the error
+-------------------------------------------------------------------
|Filename: Sample book.txt
|Download: http://www.excelforum.com/attachment.php?postid=3812
+-------------------------------------------------------------------