Quote Originally Posted by livifivil
I am using this formula for the 2nd thing but I keep getting an error message. Is this incorrect??

=COUNT(IF(PA!$G$2:$G$1027=A1;IF(PA!$A$1:$A$1027="Internal";0)))

The formula seems ok to me..tested in my computer and it displays 0 so no error message for me...