Either

=SUMIF(B1:B500,"=99",A1:A500)-SUMIF(B1:B500,"200",A1:A500)

or


=SUMPRODUCT(--(B1:B500=99),--(B1:B500<=200),A1:A500)

--

Regards,

Peo Sjoblom


"Jamie A Miller" (donotspam) wrote in message
...
I am trying to sum the amounts in column A based on the figure in Column
B.
I want the formula to sum Column A if the value in Column B is between 99
and
200. For some reason, I am having trouble with the multiple criteria part
of
this. Is there a way to do this, another function, or anything?