Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Error in sum function when using 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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to sort in Excel because of merged cells | Excel Discussion (Misc queries) | |||
retrieve text from merged cells | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Merged cells | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |