Bob,
that'll do the trick.

cheers,

B

Bob Phillips wrote:

=SUMIF(A:A,"<100",C:C)-SUMIF(A:A,"<500",C:C)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)