1. ## Non-adjacent cells and COUNTIF

I have a series of non-adjacent cells with just user input numbers in them. I want to look at each cell, determine whether the value is <10, and count how many meet that criterion. I've tried the COUNTIF function, but it tells me I have "too many arguments for this function". Yet, if I pick a series of adjacent cells, it works fine. I'm fairly novice at functions. Is there a different function I should be using?

2. ## Re: Non-adjacent cells and COUNTIF

With 365 try this

Formula:
`Please Login or Register  to view this content.`

replace the list of cells with your actual cells

3. ## Re: Non-adjacent cells and COUNTIF

The COUNTIFS() function allows for multiple criteria ranges. https://support.microsoft.com/en-us/...rs=en-us&ad=us

4. ## Re: Non-adjacent cells and COUNTIF

Perfect!! Thank you so much!!

5. ## Re: Non-adjacent cells and COUNTIF

Originally Posted by MrShorty
The COUNTIFS() function allows for multiple criteria ranges. https://support.microsoft.com/en-us/...rs=en-us&ad=us
What that will do is AND together the conditions for each range, rather than counting discontinuous ranges cumulatively. And IIRC the ranges have to be the same shape. That is,
Formula:
`Please Login or Register  to view this content.`

will count as 1 if A1 and B1 are both <10, plus 1 if A2 and B2 are both <10, and plus 1 if A3 and B3 are both <10. It sounds to me like the OP wants the equivalent of
Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)