On 22/05/2012 11:23 PM, JPP wrote:
Yea Mick, I have tried that, and unfortunately that doesnt work, because
the full selection is 1) Agent did not give their full name. It is not
counting the entires when I just do a "1".


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



Did you try expanding it to this:

A2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=1) Agent did not give their
full name.")
B2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=2) Agent did not state the
company name.")
C2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=3) Agent did not state they
were licensed.")
D2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=4) Agent did not give the scope.")
E2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=5) Agent covered this section
on one or more calls, but not all calls.")
F2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=6) Agent skipped this section.")
G2 = =COUNTIF('CCI Info'!$A$2:$G$30000,"=7) Other compliance issue.
")

HTH
Mick.