Thank you that worked. Would you tell me why the following won't work?
Thanks again.

=COUNTIF(Aliberti!$G$62:$G$74,
"="&Aliberti!$G$6*0.7)-COUNTIF(Aliberti!$G$62:$G$74,
"<="&Aliberti!$G$6*0.799)

"Domenic" wrote:

Try...

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

Hope this helps!

In article ,
"Jane" wrote:

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

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