Conditional Aggregation with Partial Match

Hi Everyone,

I have attached my spreadsheet and am hoping someone can find a way of doing the following:

Under tab "PostCodes" you see the below, I want total Bookings to basically go through all of tab "Bookings" and count up all bookings that are made in the Year entered in Cell B1 of "PostCodes" that have the post code begin with the text in "PostCode" column. And then I also with to SUM the Total order value of those in the "Total Order Value" cell.

Year: 2007

PostCode Region Total Bookings Total Order Value
AB Aberdeen
AL St Albans
B Birmingham
BA Bath
BB Blackburn
BD Bradford
BH Bournemouth
BL Bolton
BN Brighton

Anyone know how to do this as I am going in absolute circles on this.

Thanks,

Chris