+ Reply to Thread
Results 1 to 5 of 5

Merge Cells formula

  1. #1
    Forum Contributor
    Join Date
    01-14-2020
    Location
    Pakistan
    MS-Off Ver
    15
    Posts
    123

    Merge Cells formula

    Hi,

    I'm using the below formula - the outcome should be that if all N/A - then ignore, if all Yes then then 0 and if any No then count number of Nos. However it's working in the other cells but some cells are merged and it's not working, please can someone guide me on this.

    =IF(IF(COUNTIF(F32:T32,"N/A")=COUNTA(F32:T32)+COUNTBLANK(F32:T32),1,0)=1,"",IF(COUNTBLANK(F32:T32)>0,"",COUNTIF(F32:T32,"No")))

    Many thanks

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Merge Cells formula

    There are many members of this forum who would advise against using merged cells for numerous reasons including because of the very type of issue that you are seeing here. Can you possibly remove the merged cells?

    If you are not able to remove the merged cells for some reason, then I think we would need to see a sample workbook that shows the problem. To do that, follow the instructions in the yellow banner at the top of this window.

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Merge Cells formula

    Hi,
    please upload a sample of your file to see what you are doing wrong.
    Thanks

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,409

    Re: Merge Cells formula

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Formula to dynamically merge cells
    By mirzinho in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2020, 01:33 PM
  2. Apply formula for merge cells
    By JEGANKR in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2018, 02:09 PM
  3. Merge Cells with Excel formula
    By HB07 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2015, 04:45 AM
  4. Formula to merge cells
    By nik7 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-01-2013, 08:39 AM
  5. Formula with Merge Cells
    By ritu arora in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-05-2013, 12:04 PM
  6. Any formula to merge 2 cells in a column?
    By marqz in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-10-2013, 08:13 AM
  7. Replies: 0
    Last Post: 11-03-2012, 06:11 PM

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