Results 1 to 3 of 3

Thread: Count of specific text

  1. #1

    Count of specific text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    In column A we have account type, i want the total count of only BIP in cell B2, please help.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =COUNTIF(A:A,"*BIP*")


  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by dinesh.sarsar View Post
    Hi,

    In column A we have account type, i want the total count of only BIP in cell B2, please help.
    This is an almost identical question to the one resolved on 1/10/2014 !

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •