Hi
try the following:
1. Create a list of your other worksheets on your summary page. e.g. in
the cells X1:X10

2. use the following formula (assumption: cell A1 stores the value to
check against:
=SUMPRODUCT(COUNTIF(INDIRECT("'" & $X$1:$X$10 & "'!A1:A100"),A1)))


--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Would like to have a worksheet that keeps a running tally
of the number of times a specific value occurs in several
other worksheets. Is there a way to count the number of
matches to a specific value?

Thanx