Forum Discussion

Lplayer92's avatar
Lplayer92
Copper Contributor
Oct 05, 2019

Drop Down & Sumif?

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 inform...
Drop down
sumif
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 05, 2019

Lplayer92 

You missed closing bracket after first INDIRECT

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

 

Lplayer92's avatar
Lplayer92
Copper Contributor
Oct 05, 2019
Thank you!!!!!!

Resources