Selecting from two drop down lists to calculate a total amount

[changy88]

Hello,
Would like some help solving a formula please. Would like to be able to select an item from one drop down list and then select how the amount will be paid from another drop down list (i.e. visa, master card or amex) and have the amount tallied up as a total. But depending on the amounts of the items the credit card fees would be different (e.g. items costing $5 or less have visa/mastercard fee of say $1 whereas items costing $6 and upwards would have credit fee of $2. Would also like to be able to view the totals for the credit card fees collected (i.e. total amount for visa, total amount for master, total amount for amex). Have attached a picture to help with description.
Many thanks

Have now uploaded the excel file.

[Pete_UK]

A picture is not much use - far better to post a sample Excel file.

Pete

[changy88]

Certainly. Have uploaded sample Excel file.