Use COUNTIF on column that contains TRIM formula

  • Hi all



    im using the formula



    =COUNTIF(B:B, yellow)



    to find how many times yellow appears in columb "B"



    however columb "B" itself contains formula with the trim and substitute formulae that are taking information from other cells in the spreadsheet



    can this be done with a formmula similar to =COUNTIF(B:B, yellow)



    many thanks in advance for any help



    regards



    Paul

  • Re: Use COUNTIF on column that contains TRIM formula


    The TRIM function shouldn't make any difference, but you do need quote marks:


    =COUNTIF(B:B,"yellow")

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Use COUNTIF on column that contains TRIM formula


    Many thanks


    i missed the quote marks


    great forum, i usually use the paid hire section but thought this was an easy problem to sort


    thanks Again



    Paul

  • Re: Use COUNTIF on column that contains TRIM formula


    A lot can be solved without paying for it! You're welcome. ;)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules