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
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!