Assume the 3 support sheets are named: Sheet1, Sheet2, Sheet3,
and in each sheet, you are recording the receipts "x" in col E, in E1 down

In your master sheet,
you could try in say, A2:
=SUM(COUNTIF(Sheet1!E:E,"x"),COUNTIF(Sheet2!E:E,"x "),COUNTIF(Sheet3!E:E,"x"))
to return the required number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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