Multiply based on criteria

Thank you both very much - this was just what I was looking for.

I gave you both rep, but as davesexcel got there first I will mark his answer as the solved one. Also thanks for the Pivot suggestion Aardigspook, but the array will work for me.

Glad to be of help and thanks for the rep.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.