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.
Specifically column F and column H that contain the merged cells don't
add up correctly. Column F is +1 more than it should be. Column H is
+125 more than it should be.
I have been using this feature for about 6 months, and this is the
first time it did this. Any ideas why the error?
+-------------------------------------------------------------------+
|Filename: Sample book.txt |
|Download:
http://www.excelforum.com/attachment.php?postid=3812 |
+-------------------------------------------------------------------+
--
librarynut
------------------------------------------------------------------------
librarynut's Profile:
http://www.excelforum.com/member.php...fo&userid=7149
View this thread:
http://www.excelforum.com/showthread...hreadid=467043