"Pat" wrote:

Max,

I tried what you suggested but it didn't work; here's what I put
= SUM(COUNTIF(Client Relationships Certification List - Sept 20
2007.xls)Sheet 1!$I$2:$I$50))

Above is what I put in the master sheet referring back to my 1st sheet and I
keep getting an error message.

I type = in my master and then go to the supporting sheet (where the data
resides) to complete the formula and then back to the cell in my master that
I want the real time count to take place - and I keep getting an error.


Hi Pat.
I believe that Max is right and the file name is wrong. :-)
Try:
=€¦€¦..([Client Relationships Certification List - Sept 20 2007.xls]Sheet
1!$I$2:$I$50))€¦€¦..
Regards
Eliano