Tally matches??

[Guest]

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

 

[Frank Kabel]

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)))

 

[Guest]

Hmmm... Thnaks for the speedy response. It isn't working
for me. I tried putting the cells where my data is but I
get #ref error.

here's my formula
=SUMPRODUCT(COUNTIF(INDIRECT("'" & 'Summary sheet'!
$A$1:$A$7 & "'!B1:B100"),A1))

I put the names of the seven worksheets that I want to
check in column A on worksheet entitled summary sheet.

The values to be checked to see if they match value on
current sheet then counted if they do match will be on
Column B of all seven worksheets to be checked.

The value to be matched from current sheet and counted in
other 7 worksheets is in column B

Thanx for you help.