Try the following:

=SUMPRODUCT((A1:A100=F1)*(B1:B100=F2)*(C1:C100))

I have put the date to analyse in cell F1 and F2 is where you specify Air, Sea etc