Counting data ( 80% to 90%) the numbers times they appear with a range of cells

[shaggy72]

Hi everyone ,

I am looking for some advice on the following:

Performance management is a tool we have to use and I have set an excel spread sheet using conditional formatting (changes colour). But I now need to know the number times between 80% and 90%. I have used countif to find the number over 100%.

Any help would be great.

Arthur

 

[premjeetgupta]

You can use following Count if criteria

=COUNTIFS(range,">=80",range,"<=90")

Thanks