SumIf Function using multiple criteria

J

Jamie A Miller

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

Peo Sjoblom

Either

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

or


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