Relatively simple summation program

Hey y'all,

I'm a first year analyst at Deutsche Bank working on a foreign exchange team. My MD just asked me to put this together, but I still have little to no excel skills (god knows how I got this job...)

Anyway, I've got a few different currency pairs (EUR/USD, USD/JPY, etc) with what is called a 'parity value' at a number of different strike prices, all organized by date. For example, some entries in the sheet might be:

Base Currency	Target Currency	Date	Strike	Parity
EUR	USD	11-Jun	1.250	2.0
EUR	USD	14-Jun	1.550	4.0
EUR	USD	15-Jun	1.150	1.0
EUR	USD	4-Jun	1.150	3.0

Then, for EUR/USD, I have some ranges for the strike price. For simplicity, let's say my ranges are 1.0 - 1.3 and 1.3 - 1.6. What I'm trying to do is sum up the parities for each range for each week. For example, for the week ending 15-Jun, the sum of the parities for the range 1.0 - 1.3 would be 3.0 and 1.3 - 1.6 would be 4.0. Similarly, the week ending 8-Jun would be 3.0 for the 1.0 - 1.3 range.

Ideally I want to have dynamic ranges depending on the currency pair in use (as the USD/JPY would have very different levels than EUR/USD, etc).

What is the best way to go about doing this? I want to be thoughtful with regards to scalability but at the same time I don't want to lose my **** putting this together. What is the best overall approach? Any help/ideas are greatly appreciated.

Thanks a lot!


- Michael