Assuming values within A2:A10,
in say B1:
=SUMPRODUCT(($A$2:$A$10200)*($A$2:$A$10<1000),$A$ 2:$A$10)
Adapt the range to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amit Kumar Baidyaka" wrote:
Hi, please help me in sum. I have a column with different values ranging from
50 to 5000. I need to sum up only those which are more then 200 and lower
then 1000. Is this possible without the use of VB.

Thanks
Amit.