#Nested Criteria Error, but only on a few rows. What am I doing wrong?
JWells
✭✭
I dragged it down most of them work and pull, but a select few will give me the Nested Criteria Error.
Thank you in advance for any help.
Answers
-
Hello! There is a handy help article for trouble shooting formulas which output error messages. Here is an excerpt related to your Nested Criteria Error:
NESTED CRITERIA
Cause
You’ve nested criteria in a SUMIF or COUNTIF function.
Resolution
Use SUMIFS or COUNTIFS instead, as you can include multiple criteria without nesting.
If your formula works for some rows but not all then there's probably a slight difference in the data being referenced in your formula. Find the difference in your input and it'll point you in the right direction. Hope this helps.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives