COUNT NEGATIVE and POSITIVE RANGES with NUMBERS

Hi everyone I need some help on doing this ranges between negative to positive numbers, I can handle this if it using a whole number but this is concern with decimal places..so I am noob with this..

For example :
Range from -0.99 to -0.9 with number counts from it. then
Range from -0.89 to -0.8 with number counts from it
Range from -0.79 to -0.7 with number counts from it and so fort..

and also I want to add all counts that within from the ranges above...
please see the attached file
DECIMAL COUNT RANGES.xlsx

THanks in Advance...

Originally Posted by benishiryo

hi Vanther. maybe:
=SUMIFS($C:$C,$A:$A,H$2,$B:$B,">="&$F3,$B:$B,"<="&$G3)

you should probably type in the answers you wish to see manually & tell us you obtained 1 or 2 of those

i noticed you haven't replied to this thread:
http://www.excelforum.com/excel-form...ml#post3560589

aw sorry for that... I thought no one answer it...but I really appreciated it.. thanks very much...

the formula it works great...but I have a question why do we use dollar ($) sign of this? that's why I can't get the formula....work