Excel help required

[sittarah]

meray paas aik data hai jis k aik column main formula apply karnay main masla ho raha hai.Formula asal main 2 formulas ka hai.
if-else and count
actually us column main jo values misal k tor pr 7 aur 8 k darmiyan hain woh count ho gayein aur phir jo value 6 aur 7 k darmiyan hai woh aur phir issi tarha 0 tak saari main count kr loon agr koi meri help kr sakta hai tou ply meri madad gald az gald karain.
main online hi intizar kr rhi hon.
I have attatched the file there is highlighted column there are different ranges of number which i want to count between 5 to 6 and 4 to 5 and so on.
Shukriya in advance.

Allah Hafiz