ExcelBanter - SumIf Function using multiple criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SumIf Function using multiple criteria (https://www.excelbanter.com/excel-worksheet-functions/11621-sumif-function-using-multiple-criteria.html)

Jamie A Miller

SumIf Function using multiple criteria

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?

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)

--

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?

All times are GMT +1. The time now is 11:53 PM.