=SUMIF(A2:A20,"200")-SUMIF(A2:A20,"=1000")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Amit Kumar Baidyaka" wrote in
message ...
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.