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

Vaya con Dios,
Chuck, CABGx3


"CLR" wrote in message
...
=SUMIF(A:A,"<200")-SUMIF(A:A,"<=100")

Vaya con Dios,
Chuck, CABGx3


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