Some help needed with IF(AND... formula please

Good idea.

Test sheet attached. The data I am working on is at the top, and the red table underneath would be the kind of thing I am hoping to acheive. Only problem being I want it to see Guest (Adult) and Catalogue as an Adult field, I thought I could use *'s e.g. =IF(AND(A5="Beavers",B5="*Adult*",C5="Booking"),E5,0)

But that doesn't work.

I'm finding it hard to explain but I hope you can see what I want.

Thanks Whizbang I'll try that as soon as I have a chance (probably next week)