+ Reply to Thread
Results 1 to 3 of 3

Counting non-empty merged cells on another closed document with SUMPRODUCT

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    48

    Counting non-empty merged cells on another closed document with SUMPRODUCT

    Hello.
    I am trying to count non-empty cells on another closed document with SUMPRODUCT.
    I am using this formula:
    Please Login or Register  to view this content.
    Everything seems fine until the array encounters merged cells and returns #REF! from those cells, as seen in formula evaluation window:
    gkTFa.png
    How to solve this problem. Easiest way is just to unmerge those cells or there are other formulas? Maybe there is a way to change those #REF! to 1's? Or maybe a VBA macro would be more suitable?

    Thank you for your insights and help.

    P.S. question also posted here 23 hours ago. https://stackoverflow.com/questions/...ith-sumproduct

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,112

    Re: Counting non-empty merged cells on another closed document with SUMPRODUCT

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    48

    Re: Counting non-empty merged cells on another closed document with SUMPRODUCT

    The formula started to work for some reason.
    Marking as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inserting data in the next empty row that contains horizontally merged cells
    By karimretina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2020, 03:59 PM
  2. Replies: 8
    Last Post: 07-30-2018, 07:06 PM
  3. Replies: 1
    Last Post: 10-06-2015, 06:55 PM
  4. Counting merged cells *Please Help!*
    By lindaung0824 in forum Excel General
    Replies: 12
    Last Post: 05-27-2015, 04:01 AM
  5. SUMPRODUCT and merged cells.
    By skatmandu2002 in forum Excel General
    Replies: 3
    Last Post: 12-29-2014, 09:14 AM
  6. Data sort, empty formula cells to bottom merged cells!
    By ikkuh in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-09-2013, 03:10 AM
  7. Copy range A1:D9 with merged cells to the next empty row
    By Temporary-Failure in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2010, 03:18 PM

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