COUNTIFS with reference to another sheet more than one criterion
I'm very confused about this function. It has an #UNPARASABLE error.
=countifs({Jade2_BCM Dashboard 2019 Range 1},"Complete",[{Jade2_BCM Dashboard 2019 Range 2},"Business Resilience",{Jade2_BCM Dashboard 2019 Range 3},"1st Quarter")
I am trying to reference three columns from another sheet, Jade2_BCM Dashboard, to see how many rows are marketed as complete, are from the 1st Quarter, and are under Business Resilience. Does anyone know why I am getting this error?
Comments
-
Try removing the [ in "Complete",[{Jade2_BCM Dashboard 2019 Range 2}, the [ ] are used when referencing a column name in the same sheet that has a space in it, it is not required when referencing columns in another sheet.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
-
Thank you! That worked. I no longer have an error.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!