+ Reply to Thread
Results 1 to 2 of 2

COUNTIF Not Exact Match

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Oxford, England
    MS-Off Ver
    Excel 2010
    Posts
    47

    COUNTIF Not Exact Match

    Hi All

    I've looked at recent questions similar to this to see if they would solve my issue but to no avail

    I need the COUNTIF function to count a range of cells what include certain text but not the whole cell

    For example cell C2 contains ABC 1.2.3 A1 - ALPHA cell C3 contains ABC 1.2.4 A2 - BRAVO

    I want the function to count the cell content upto the .3 or .4 ignoring anything after that as the codes only vary after the last .number

    Please help

    Thanks all

    Dan

  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,440

    Re: COUNTIF Not Exact Match

    Try:

    =SUMPRODUCT(--(LEFT($C$2:$C$5,7)=LEFT($C2,7)))

    Change the range $C$2:$C$5 as necessary


    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


+ Reply to Thread

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