|
|
| Count
based on a Single Criteria across Multiple Sheets |
Sheet1
Sheet2
Sheet3
Summary
The
following formula counts the number of times a value in G2:G5, across
all
sheets listed in B2:B4 of the Summary sheet, equals the value in D2 of
the Summary sheet...
=SUMPRODUCT(COUNTIF(INDIRECT("'"&B2:B4&"'!G2:G5"),D2))
Based on the sample data, the formula returns 5. Sample
Workbook
|
|
|
