#1
|
|||
|
|||
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
|
||||
|
||||
The criteria you want to add is already in your formula ?
Do you mean =SUMPRODUCT((INDIRECT("'"&A6&"'!B:B")=I5)*INDIRECT ("'"&A6&"'!G:G"))
__________________
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 |