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.

 

 

Capture_0.JPG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!