Trying use vlookup and countif

[Dhurl]

Hi

I'm looking for help on isolating and breaking down some figures

Customer Type Payment Credit Limit Credit Check Total Amount Difference
Bus test 1 Direct Debit 90 <=100 80 10
Business Cash 90 <=100 200 -110
Bus 3 Direct Debit 80 <=100 20 60
Bus test 1 Direct Debit 20 <=100 120 -100
Bus test 1 Cash 20 <=100 10 10
Business Direct Debit 40 <=100 45 -5

I want to isolate 'Bus test 1' and count the average 'total amount' and total 'total amounts'

Can anyone help with this please?

 

[pjmorris]

Hi Alan, Many thanks - I suspect it won't work as this is a works computer, but I'll give it a try.