countif question

[Brown]

Good Morning, and thanks for the help.

I am working with a string of 169 grades (numbers), >90, <70, 80-89, 70-79
I am good with countif on the >, < but need help with those two ranges.
Is countif the best formula to use, and if so how to i use it for the ranges, and if not what would you suggest?

Thanks again for the help, you guys always come through and I have learned so much on here.
Have a nice day
Brown

 

[Fluff]

Something like
=COUNTIFS(A:A,">=80",A:A,"<=89")

 

[tyija1995]

Hey,

For ranges like that I prefer SUMPRODUCT,

=SUMPRODUCT((A:A>=80)*(A:A<=89))

Will return how many numbers in column A are between 80 and 89

 

[Brown]

AWESOME!!
Thank you guys so very much.
I will give these a try right now.

Have a great day and thanks for the help
Brown

 

[Fluff]

Glad we could help & thanks for the feedback