im using the formula
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