creiteria in sumif

[Frank Kabel]

Hi
try
=SUMIF(range,">100")-SUMIF(range,">=200)

or use SUMPRODUCT:
=SUMPRODUCT(--(range>100),--(range<200))

See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[CLR]

=SUMIF(A:A,"<200")-SUMIF(A:A,"<=100")

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Opps, sorry............I didn't notice the OP's system clock was off, and
that Frank had previously answered...........

Vaya con Dios,
Chuck, CABGx3

 

[hassan barjini]

Hi
I would like to add this creiteria in sumif
"and( >100 , <200)"
there is no answer why ?