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
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
=sumproduct((A1:A20>=4)*(A1:A20<=5))
this should work you just need to adjust the range to your data.
=countif(A1:A100,">=4")-countif(A1:A100,">5")Originally Posted by Shirley Munro
BenjieLop
Houston, TX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks