Help - Sumif Column Based on Absolute Value Critera

[flasty]

Hello, thanks in advance for help.
(using Excel 2007)
I want to sum all the values in a column that fall within a certain range of that column's absolute value. The absolute value range is the criteria; however, I would like resultant sum to be based on the actual numbers not the absolute value.

For instance:

Column A
-5
5
4
3
-9
10

I would like to sum all the values in a portion of a column whose absolute value is >=5 but <=10. In this case the result I seek would be a total of 1.

I have tried nesting an absolute value range as the criteria in the sumif function but many attempts have left me confused, frustrated and now somewhat doubtful that the sumif function is the proper way to achive the desired result

Any suggestions would be much appreciated. Thanks

 

[JoeMo]

Excel Workbook
	A	B	C
1	-5
2	5		1
3	4
4	3
5	-9
6	10
Sheet9

 

[flasty]

Thanks for your help! Worked perfectly.