SUMIFS (Several Critera)

Hi There,

I am trying to sum the values from one range of cells depending on several criteria from one sheet to another. I am trying the SUMIFS, not sure if this is the best.

I want to sum the revenue of all "AIR" shipments with a weight between 300 to 500.

Quite basic probably, but I am really stuck here. I attach a sample in excel also, where the result should be 300 in revenue. Might be easier perhaps seeing the excel doc itself.

Thanks and Best regards,

Mackan7695