+ Reply to Thread
Results 1 to 3 of 3

Countif help

  1. #1
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London, England
    MS-Off Ver
    EXCEL 2013
    Posts
    324

    Countif help

    Hey guys
    Hope all is well
    I need some help,

    Aim- To count how many unique “MID Internal (Merchant ID)” (column B) fall under “# of Calls” Column I

    For eg
    “MID Internal (Merchant ID)” = ‘878022420888’ (highlighted yellow) Row 8 & 9 is in my data twice, however i want it count against the “# of Calls” = “Less than 2” just the once

    “MID Internal (Merchant ID)” = ‘878187094882’ (highlighted green) Row 22 & 28 is in my data seven times, however i want it count against the “# of Calls” = “Five - seven ” just the once
    Please find attached my excel

    Would appreciate any help available
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Countif help

    Add a helper column and add this formula:

    =IF(COUNTIF($B$2:$B2,$B2)=1,1,"")

    or

    =IF(COUNTIF($B$2:$B2,$B2)=1,"count","")


    With the first, you can just SUM the helper column; with the second you can use COUNTIF to count the records.

    For example: =SUM(J2:J28)


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Countif help

    Another approach..

    All below formulas are need to confirm by Ctrl + Shift + Enter

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    to count the No Of Unique code only in MID column..

    and in case you also want to
    against the “# of Calls” = “Less than 2” just the once
    then use this..
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

+ Reply to Thread

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