T Tammy Oct 31, 2003 #1 How can I count the # of times something occurs across multiple worksheets in a workbook? Thanks!
P Peo Sjoblom Oct 31, 2003 #2 =SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{1,2,3}&"'!A1"),">5")) the above would count how many cells A1 is greater than 5 in sheets 1 to 3
=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{1,2,3}&"'!A1"),">5")) the above would count how many cells A1 is greater than 5 in sheets 1 to 3
