hi guys

on sheet 1 cell b1 im trying to count how many times the word ' arsenal ' appears on sheet 'AUTO' column d and return that number

then in sheet 1 cell c1 i need it to count the total points in 'AUTO' column g in every row that arsenal appears in

any help would be gratefully received