Results 1 to 3 of 3

How to sum all the unmerged cells next to a merged cell (repeatedly)?

Threaded View

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    Brunswick, ME
    MS-Off Ver
    Excel 2007
    Posts
    10

    How to sum all the unmerged cells next to a merged cell (repeatedly)?

    Hopefully the screenshot explains what I want.

    There are several manufacturers in Column B, and the products they make are in Column C.
    The manufacturer's name is in a merged cell that spans all the products they make.
    Column E is the # of units sold for each product.

    I want to rearrange the manufacturers - currently they're in alphabetical order.
    What I want is for them to be in order by highest number of units sold, to lowest.
    It would be nice also to have a cell showing the totalled units for each manufacturer.

    What is a logical way to do this? It's hundreds of rows so I don't want to do it manually.

    \1
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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