How to count a range of numbers, erm, in a range

[dkflameboy]

Help please!

I have a range of different percentages in column V4-V78, I want to create a formula that will count how many times the percentage of 80%-99% appears in this column. I will then need to repeat the process for 60%-79%, so on and so forth. Eventually the column will be far greater than just the 70 rows it currently is. I can't figure out how to do it so help would be much appreciated.

Many thanks

 

[Rick Rothstein]

Maybe...

=COUNTIFS(V4:V78,">=80%",V4:V78,"<100%")

which could also be written without the percent signs if desired...

=COUNTIFS(V4:V78,">=0.8",V4:V78,"<1")

 

[dkflameboy]

Worked like a charm, thank you