Drop Down & Sumif?

[Lplayer92]

SOS
Where am I going wrong ‘too many arguments’

=sumif(indirect(“‘(“&d1&”)’!$C$3:$C$25”,$C$4, indirect(“‘(“&d1&”)’!$D$3:$D$201”))

There’s got to be a way to create a drop down that pulls information from multiple multi column tabs that match specified cell criteria

[#2]

@Lplayer92 

You missed closing bracket after first INDIRECT

=SUMIF(INDIRECT("'("&D1&")'!$C$3:$C$25"),$C$4, INDIRECT("'("&D1&")'!$D$3:$D$201"))

[#3]

Thank you!!!!!!

[#4]

@Lplayer92 , you are welcome