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?
|