Help with a 2013 marketing Calendar

[jame24]

Hey Everyone,

I am in the process of creating a marketing calender for the new year and am having trouble aggregating the different marketing amounts into one sum.

For each day, I want to be able to choose 8 different options of how to advertise (this is done using a vlookup). Each of these options is either internal or external and either Radio or Print.

I am having trouble creating a formula to which knows if option 1 vs option 2 is internal or external and how it sums it all up so that i can create a pie chart from it.

I have attached the spreadsheet for reference.

Any help of guidance will be greatly appreciated.
Thanks