Home

Drop Down & Sumif?

%3CLINGO-SUB%20id%3D%22lingo-sub-895115%22%20slang%3D%22en-US%22%3EDrop%20Down%20%26amp%3B%20Sumif%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895115%22%20slang%3D%22en-US%22%3ESOS%3CBR%20%2F%3EWhere%20am%20I%20going%20wrong%20%E2%80%98too%20many%20arguments%E2%80%99%3CBR%20%2F%3E%3CBR%20%2F%3E%3Dsumif(indirect(%E2%80%9C%E2%80%98(%E2%80%9C%26amp%3Bd1%26amp%3B%E2%80%9D)%E2%80%99!%24C%243%3A%24C%2425%E2%80%9D%2C%24C%244%2C%20indirect(%E2%80%9C%E2%80%98(%E2%80%9C%26amp%3Bd1%26amp%3B%E2%80%9D)%E2%80%99!%24D%243%3A%24D%24201%E2%80%9D))%3CBR%20%2F%3E%3CBR%20%2F%3EThere%E2%80%99s%20got%20to%20be%20a%20way%20to%20create%20a%20drop%20down%20that%20pulls%20information%20from%20multiple%20multi%20column%20tabs%20that%20match%20specified%20cell%20criteria%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-895115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDrop%20down%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esumif%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-895129%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%20%26amp%3B%20Sumif%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895129%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420694%22%20target%3D%22_blank%22%3E%40Lplayer92%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20missed%20closing%20bracket%20after%20first%20INDIRECT%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DSUMIF(INDIRECT(%22'(%22%26amp%3BD1%26amp%3B%22)'!%24C%243%3A%24C%2425%22)%2C%24C%244%2C%20INDIRECT(%22'(%22%26amp%3BD1%26amp%3B%22)'!%24D%243%3A%24D%24201%22))%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-895133%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%20%26amp%3B%20Sumif%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895133%22%20slang%3D%22en-US%22%3EThank%20you!!!!!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-895134%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%20%26amp%3B%20Sumif%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420694%22%20target%3D%22_blank%22%3E%40Lplayer92%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Lplayer92
New Contributor
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
3 Replies

@Lplayer92 

You missed closing bracket after first INDIRECT

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

 

Thank you!!!!!!

@Lplayer92 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies