Results 1 to 11 of 11

Formulas don't count merged cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Monaco
    MS-Off Ver
    Excel 2010
    Posts
    31

    Formulas don't count merged cells

    Hi there,

    I'm sorry if this is a basic problem - I can't seem to find exactly the solution I'm looking for...

    I want to count the number of times we have sold models manufactured between 1965 and 1980. Unfortunatly, some models have had more than one owner... As soon as we have a one model sold several times, we are using merged cell, but then the formula stops working because of the merged cells (see attached sample document). Hopefully I'm making sense... Can anyone give tips on how to solve this issue?

    Thanks in advance,
    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