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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS, one criteria range, multiple criteria 2
Use TODAY() function as the criteria in a SUMIF formula 1
Multiple Columns in Sum Range using SUMIFS 1
VLOOKUP or SUMIF for Multiple Criteria 2
SUMIF with criteria "<>" & "=" 4
SUMIF with Certain Criteria 1
Help with SUMIFS 2
sumif issues 1

Top