SUMIF Issue?

[VPGator]

Hi,

I have a formula that I need to fix that presents the total amount of products owned within all my worksheets. I have a master sheet & have this formula in it currently =SUMIF(I:I,"GOOGL",S:S) to search and sum up the total amount of products in reference to Google's stock symbol.

I have tried using =SUMPRODUCT(SUMIF(INDIRECT( formulas to create the same outcome to sum up the total amount of products from all other sheets, to sum in the master, but can't figure out the correct formula. I need the column ranges to be the same - I:I and S:S, but have the total come to the master page. It would be greatly appreciated if I could get this fixed! Thank you.

Regards,

[TABLE="width: 80"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[63falcondude]

Cross-posted here:

https://www.excelforum.com/excel-formulas-and-functions/1212433-sumif-issue.html

 

[Marcelo Branco]

See
https://exceljet.net/formula/3d-sumif-for-multiple-worksheets

M.

 

[Joe4]

Note that while we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[VPGator]

Thank you for sharing with me. I appreciate @63falcondude for providing it. I will be sure to include it next time.

Cross-posted here:
https://www.excelforum.com/excel-for...mif-issue.html