+ Reply to Thread
Results 1 to 2 of 2

Does not Equal inside of Countifs

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    30

    Does not Equal inside of Countifs

    Hi,

    I have a formula that looks like the following:

    =IF(COUNTIFS(J:J,J15,AM:AM,ABS(AM15),AD:AD,AD15,AX:AX,"<>"AX15)>1,"Duplicate","")

    The AX15 will not even register in a color when the "<>" there. I only want the formula to count the rows where the value in AX:AX does not equal AX15. What is wrong with this formula?

    Thanks,
    Justin

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Does not Equal inside of Countifs

    You have to concatenate:

    =IF(COUNTIFS(J:J,J15,AM:AM,ABS(AM15),AD:AD,AD15,AX:AX,"<>"&AX15)>1,"Duplicate","")
    Remember what the dormouse said
    Feed your head

+ 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. [SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values
    By AliciaRenee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 03:57 PM
  2. [SOLVED] Countifs using not equal
    By rrcrossman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2013, 11:33 AM
  3. [SOLVED] Dynamic date check inside Countifs
    By mtnbiker98 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 04:16 PM
  4. Replies: 9
    Last Post: 12-09-2012, 08:37 PM
  5. [SOLVED] External Links Not Updating when inside COUNTIFS
    By sunsoar77 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2012, 12:20 AM

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