Formula Question VLOOKUP SUMIF COUNTIF

Hello,

I need help creating a formula that will do the following

Lookup O/N, if there are 2 or more matches it needs to add the quantities together.
It also needs to then count all of the O/N with a total quantity of between two number for example 1 and 499, and exclude the orders that are cancelled.

I have attached an example excel sheet

Thank you

Try this in C16

=SUMIFS($F$2:$F$12,$F$2:$F$12,">=1",F2:F12,"<=499",$A$2:$A$12,$B16)

You'll have to adjust the 1 and 499 to 500 and 999 for the next cell.

Hi,

Thank you for your help, however this returns 100?

I need a formula that would return the total number of orders with quantities between 1 and 499. but also remove the cancelled orders, and add up the quantities for o/n's that recur more than once

100 represents the SUM of the quantities for January that were between 1 and 499
There was only 1 that met that criteria, and it was 100 in F3.

Maybe I'm not understanding the rquirement.
Can you post another file that has your expected results entered by hand, just for a few, say January and February for 1-499 and 500-999?

Please see the attachment. May be this is what you want.

Hey I'm trying to insert a function that says "if cell B3 is 750 ml, then cell C3 is 25.36." And "if cell B4 is 1 L, then cell C4 is 33.81." In other words, one column states the size of bottle and the next column is how many ounces are in that bottle. I have been searching all morning how to make this happen but am striking out everywhere. Please help!