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, 12 views)