Hi Jane

Try

=COUNTIF(Aliberti!G40:G53, "="&Aliberti!G6)

Regards

Roger Govier


Jane wrote:
Would someone tell me why the following doesn't work? Thank you.

=COUNTIF(Aliberti!G40:G53, "=Aliberti!G6")