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.

Thanks.
--
Pat



"Pat" wrote:

Hi,
I've got 3 to 4 worksheets that i'd like to lind to a master that is
automatically updated each time i make a change to the support 3 - 4
worksheets. All i'm trying to do is track the number of tests i receive on a
realtime basis. I simply note the receipt on the supporting worksheets with
an X and would like it to show on the master worksheet as a number. for
instance if i've received 35 tests than the 35 X's should appear as the # 35,
and as i add another X it goes up to 36 on the master worksheet.

How can i do this? Regards,
--
Pat