Results 1 to 1 of 1

Error in sum function when using merged cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2004
    Location
    CA
    Posts
    2

    Exclamation 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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1