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,