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?
-
I get a #NO MATCH
-
Is that error anywhere within either of your two referenced columns?
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!