View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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