|
|
|
|
#1
02-14-2014, 02:51 AM
|
|||
|
|||
Hi, i am struggling to search through multiple worksheets, for multiple criterias, to bring back a single value ion my summary page. I have attached a sample.
I need to search all worksheets for the description and Grade, so i can have an overall total on my summary page of how many eg. 9.0mm BB/CP packs are left in stock across all worksheets. when creating a: =SUMPRODUCT(SUMIF(INDIRECT("'"&A6&"'!B:B"),I5,INDI RECT("'"&A6&"'!G:G"))) Across multiple criterias, do i need to add another:- INDIRECT("'"&A6&"'!B:B"),I5 to my formula? 
|
|
#2
02-14-2014, 10:30 AM
|
||||
|
||||
|
The criteria you want to add is already in your formula ?
Do you mean =SUMPRODUCT((INDIRECT("'"&A6&"'!B:B")=I5)*INDIRECT ("'"&A6&"'!G:G"))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 sumproduct formula to pull info from multiple sheets
|
Berk21 | Excel | 7 | 01-15-2012 11:41 AM |
|
form a database from multiple sheets
|
udea | Excel | 1 | 04-25-2011 02:34 AM |
|
How do I merge data from one sheet in a workbook out into multiple sheets
|
nolesca | Excel | 4 | 06-07-2010 08:13 AM |
| Print Multiple Sheets Double-Sided | flambe99 | Excel | 1 | 03-12-2010 01:15 PM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Mac OS X 
Office for Mac 2011
Hybrid Mode