1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

=COUNTIF(B3:B101, "https") ?? resulting in 0? Excel Help pLease

Discussion in 'General Programming Chat' started by ThatSEO, Apr 7, 2017.

  1. ThatSEO

    ThatSEO Jr. VIP Jr. VIP

    Joined:
    Jan 22, 2016
    Messages:
    707
    Likes Received:
    299
    Gender:
    Male
    Occupation:
    Self employed marketing stuff
    Location:
    Sometimes UK
    So I'm pulling a list to show the top 100 results for a few niches.

    Row B has the full URLS for 100 results, some http and some not... I'm simply trying to count the HTTPS vs HTTP

    I'm using =COUNTIF(B3:B101, "https")

    However, I'm only getting 0 as my answer?
     
  2. Captain America

    Captain America Newbie

    Joined:
    Apr 8, 2017
    Messages:
    24
    Likes Received:
    8
    Gender:
    Male
    Put asterisks around it bruhh

    =COUNTIF(B3:B101, "*https*")