I need to count all the cells on one column with "Green" in them, but only
when another column has cells in a range with a value starting with "CC". I
tried to use the following formula, thinking that wildcard characters would
work, but a value of zero is returned. However, if I state the full name of
the "CC" cell, it works. Anyone got any ideas please?

=SUMPRODUCT(--($O$43:$O$268="Green"),--($D$43:$D$268="CC_*"))