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

Haha...yes. I my mistake. I did it a bit too quickly...

Thank you for a quick reply!

//M

OR,

Try the following:

=SUMPRODUCT(--(A1:A10="AIR")*(B1:B10>=300)*(B1:B10<=500),C1:C10)

Excellent...thanks.

//M

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.