Unparseable error sumifs with cross sheet reference
Hi team,
I cannot get rid of the unparseable error for the following formula. I think the issue is the =[Month]@row and =[Country]@row. I have tried also without the brackets [].
=SUMIFS({EMEA KPI Issues No of EE},{EMEA KPI Issues Category},"vendor missed data",{EMEA KPI Issues Country}, =[Country]@row,{EMEA KPI Issues Month}, =[Month]@row))
I want the formula to sum all numbers mentioned in cross sheet reference column EMEA KPI Issues No of EE when the category is "vendor missed data" (so far it works) and when the cross sheet reference column EMEA KPI Issues Country has the same value as my current sheet column "country". that does not work. Can someone help?
Thanks a lot in advance,
Judith
Best Answer
-
You have an extra closing parenthesis on the end, try this:
=SUMIFS({EMEA KPI Issues No of EE},{EMEA KPI Issues Category},"vendor missed data",{EMEA KPI Issues Country}, =[Country]@row,{EMEA KPI Issues Month}, =[Month]@row)
Answers
-
You have an extra closing parenthesis on the end, try this:
=SUMIFS({EMEA KPI Issues No of EE},{EMEA KPI Issues Category},"vendor missed data",{EMEA KPI Issues Country}, =[Country]@row,{EMEA KPI Issues Month}, =[Month]@row)
-
thank you so much! it works!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!