COUNTIFS not Counting
i am having trouble getting a COUNTIFS formula to work. what i want it to do is count Sleeve ID based off of Sleeve Length. For example I want it to tell me there are 20 6"ø Sleeves that are 8" Length. For some reason it is not counting I have attached a screenshot with the formula in it. for ease, here is the formula again -
=IFERROR(COUNTIFS([Sleeve ID]:[Sleeve ID], [Sleeve Size]5, [Sleeve Length]:[Sleeve Length], [Sleeve Size]13), 0)
I added the IFERROR to give me a 0 if nothing comes up. I tried to remove that and it didn't work.
Comments
-
Are you getting a zero when you remove the IFERROR, or are you getting an error?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I get a #NO MATCH
-
Is that error anywhere within either of your two referenced columns?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
There was, I got rid of them and it seems to be working now...
So what I am gathering is the formula will kick back what errors are in the columns while ignoring the data that is being asked for. Now the formula works like a charm.
Thank you sir.
-
Basically yes. If the formula encounters any error within the data being evaluated, it will either return the error it is encountering or it will return #BLOCKED. It just depends on the specific error present in the data to be evaluated.
Glad you were able to get it working. Happy to help!
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!