Results 1 to 2 of 2

Thread: Countif

  1. #1

    Countif



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

    Can you do a partial statement for the range? I don't have an easy way to remove the additional digits from column b
    Example

    Column A is my range column B would be the criteria and C would be the countif statement
    Column A Column B Column C
    1650 1649-11 0
    1670 1650-11 1
    1688 1688-11 1

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    How about:

    Code:
    =COUNTIF(A:A,LEFT(B2,4))
    Cheers,

Posting Permissions

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