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