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?
With 365 try this
Formula:
Please Login or Register to view this content.
replace the list of cells with your actual cells
The COUNTIFS() function allows for multiple criteria ranges. https://support.microsoft.com/en-us/...rs=en-us&ad=us
Originally Posted by shg
Perfect!! Thank you so much!!
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)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks