Forum Discussion
Lplayer92
Oct 05, 2019Copper Contributor
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 information from multiple multi column tabs that match specified cell criteria
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
3 Replies
Sort By
- SergeiBaklanDiamond Contributor
You missed closing bracket after first INDIRECT
=SUMIF(INDIRECT("'("&D1&")'!$C$3:$C$25"),$C$4, INDIRECT("'("&D1&")'!$D$3:$D$201"))
- Lplayer92Copper ContributorThank you!!!!!!
- SergeiBaklanDiamond Contributor
Lplayer92 , you are welcome