|
|
| Sum
based on a Single Criteria across Multiple Sheets |
Sheet1
Sheet2
Sheet3
Summary
The
following formula returns the sum of H2:H5, for each sheet
listed in
B2:B4 of the Summary sheet, where the corresponding value in
G2:G5 equals the
value in D2 of the Summary sheet...
=SUMPRODUCT(SUMIF(INDIRECT("'"&B2:B4&"'!G2:G5"),D2,INDIRECT("'"&B2:B4&"'!H2:H5")))
Based on the sample data, the formula returns 150. Sample
Workbook
|
|
|
