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?

Attached Files

Workbook1.xlsx (37.7 KB, 10 views)

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