If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tally matches??
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 |
#2
|
|||
|
|||
Tally matches??
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 |
#3
|
|||
|
|||
Tally matches??
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VLookup with multiple matches - need to combine | Mark Wolven | Worksheet Functions | 2 | June 24th, 2004 08:14 PM |
"Match" Function - how to find multiple matches ?? | Keith | Worksheet Functions | 2 | March 2nd, 2004 11:27 AM |
Many Matches | Andrea | Worksheet Functions | 3 | February 3rd, 2004 10:09 PM |
Various Matches | Andrea | Worksheet Functions | 1 | January 30th, 2004 04:29 PM |
Compare 2 Worksheets & Find Matches | Mark | Worksheet Functions | 1 | September 15th, 2003 05:30 PM |