Sum with given criteria !
 

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.

Sum with given criteria !
 

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.

Sum with given criteria !
 

=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.