Count repeat numbers in column B based on a condition from Column Al

Hi there,

Time to ask for help, as i have spent some hours searching for what is probably a simple answer.

I want to count how many numbers in column B belong within a range based on the condition in column A.

I have found the following formula which counts greater than:
=COUNTIFS(A1:A6,"1",B1:B6,">0")

But I need a formula which Counts values in Column B between 0-10 based on the condition in Column A.

I hope this makes sense, it is doing my head in.

Thanks in advance for any feedback.

Adam

Not sure what the condition in column A is about, but to count the number in B1:B6 in the range 0-10 you'd want:

=COUNTIFS(A1:A6,"1",B1:B6,">=0",B1:B6,"<=10")

That is exactly what i needed. It works.
Thanks very much.