How do I use CountIf between ranges

[Shirley Munro]

I have a list of percentages and I want to count which ones are greater than or equal to 4% and less than or equal to 5%. Have tried CountIf combined with And but can't get a valid answer.

Shirley Munro

[dcronje]

=sumproduct((A1:A20>=4)*(A1:A20<=5))

this should work you just need to adjust the range to your data.

[BenjieLop]

I have a list of percentages and I want to count which ones are greater than or equal to 4% and less than or equal to 5%. Have tried CountIf combined with And but can't get a valid answer.

Shirley Munro

=countif(A1:A100,">=4")-countif(A1:A100,">5")