SUMPRODUCT, multiple criteria including ranges that are listed horozontally

Hi guys,

Please see attached workbook (hopefully it attached ok)

I am looking to return a rate from a table based on 4 criteria

1. Freight type = B2 (vertical range A4:A22)
2. Trailer/Deck (qty) = C2 (horozontal range with duplicate values B11:AG11)
3. KMS travelled >= to A2 (horozontal range with duplicate values B12;AG12)
4. KMS travelled <= to A2 (horozontal range with duplicate values B13;AG14)

Value returned should be $4.60

I can see why this might not work with the kms qty range (horizontal and containing duplicates for each iteration of trailer & deck qty). Any advice on formula corrections or table reformat would be much appreciated, cheers.

Sorry forgot to put the formula i tried in the text: =SUMPRODUCT(B14:AG22,(A14:A22=B2)*(B11:AG11=C2)*(B12:AG12>=G58)*(B13:AG13<=G58))

Sorry!! both should read A2 (KMs Travelled) I copy pasted it from another work book

=sumproduct(b14:ag22,(a14:a22=b2)*(b11:ag11=c2)*(b12:ag12>=a2)*(b13:ag13<=a2))

Dang that was an obvious mistake. Thanks mate