+ Reply to Thread
Results 1 to 5 of 5

COUNTIF - Values match

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Question COUNTIF - Values match

    Hi,

    Trying to count the number of records expressed by a wildcard. The formula returns a count in the wizard, but not on the sheet itself after clicking "OK".

    For example:

    Android 5.0.1
    Android 5.0.1
    Android 5.0.2
    Android 5.0.2
    Android 5.0.3
    Android 5.0.4
    Android 6.0.2
    Android 6.0.1
    Android 6.0.1
    Android 6.0.3
    Etc


    Looking for the formula to count all "Android 5*"..

    Many thanks in advance!

    Z

  2. #2
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: COUNTIF - Values match

    Quote Originally Posted by zudecke View Post
    Hi,

    Trying to count the number of records expressed by a wildcard. The formula returns a count in the wizard, but not on the sheet itself after clicking "OK".

    For example:

    Android 5.0.1
    Android 5.0.1
    Android 5.0.2
    Android 5.0.2
    Android 5.0.3
    Android 5.0.4
    Android 6.0.2
    Android 6.0.1
    Android 6.0.1
    Android 6.0.3
    Etc


    Looking for the formula to count all "Android 5*"..



    Many thanks in advance!

    Z
    Use this code

    =COUNTIF(A1:A10,"*"&"5"&"*")


    EDIT:

    =COUNTIF(A1:A10,"*"&"Android 5"&"*")

    Thanks
    If myself or others have helped, please add to our reputation by pressing the 'Star' icon below this.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: COUNTIF - Values match

    Simply

    =COUNTIF(A1:A12,"Android 5*")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Thumbs up Re: COUNTIF - Values match

    Thanks guys! Much appreciated!

  5. #5
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: COUNTIF - Values match

    Please consider adding to our reputations if any of us have help you.

    Many thanks

+ 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. Replies: 5
    Last Post: 02-18-2017, 11:21 AM
  2. [SOLVED] =IF Any 2 Values in A1 Appear in C1, Then B1 ="Yes" (Search, Match, Countif, Index, ?)
    By ThanksAlot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2015, 11:26 AM
  3. [SOLVED] Countif Match- multiple values issue
    By jayclinton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2015, 11:16 AM
  4. Replies: 6
    Last Post: 01-16-2014, 01:30 PM
  5. Replies: 4
    Last Post: 07-16-2012, 06:22 AM
  6. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  7. COUNTIF to match criteria values from 2 columns
    By Zyphon in forum Excel General
    Replies: 4
    Last Post: 09-22-2009, 05:27 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