SumProduct Question

[Pestomania]

Hello,

I am using the following formula and currently it does what it was designed to do which is to count how many times a number shows up. But I want it to find that number and add the value in the next column.

=SumProduct (countif(indirect("'"&H9&"'!A1:Z10000"),A4))

First off I want it to find the value in A4 on any sheet that includes the word "Reserved". The value it will be trying to find is in column "A" on those sheets.

Then I want it to add the value in column "B" for each instance.

I'm not sure if that makes sense.

I've thought about using a VLookup but not sure how to make it search all sheets that include "Reserved" in the name.

Thank you

 

[sheetspread]

Try here:

https://www.mrexcel.com/forum/excel-questions/741879-vlookup-across-multiple-worksheets.html

 

[Pestomania]

Unfortunately that doesn't work because it stops at the first match. I need it to add all instances together.

 

[sheetspread]

Maybe:

https://www.mrexcel.com/forum/excel...multiple-sheets-multiple-values-returned.html