Google Sheets COUNT/FILTER function

Question

I'm having some trouble getting these functions to work. I'm not even sure if they're the ones that I should be using, but here is the following information I can provide. I had previously opened a topic, but I was getting responses about my confusing query. So, hopefully this one is better explained.

I have data in the following fields: A1:N7, as well as A12:L18. I need a function to check all of the fields and add up the amount of times certain numbers show up. The numbers that need to be checked are: <90, 90-99.99, 100-109.99, and =>100.

First off, I can use this formula to count the <90 and =>100 values in all the fields, which works.

=COUNTIFS(A1:N7,"<90")

However, I'm unsure how to appropriately add the results from A12:L18 into it. My attempts have failed. Likewise, for the ranged functions, I'm completely lost. I've tried something like this:

=COUNT(FILTER(A1:N7,A1:N7>=90,A1:N7<=99.99))

Yet, this always returns 0 as the result. In addition, like the above formula I don't know how I'd nest in a way to check the additional fields in A12:L18.

Answer 1

You just need count rows your matrix with ROWS()

=ROWS(FILTER(...))