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

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