On one tab I have the following data:

Month Currency Amount
1 JPY 50.00
3 GBP 75.00
4 JPY 50.00
7 GBP 35.00

On another tab, I've setup the Sumproduct formula to give me the amounts
that correspond with the correct currency, but how can I get a total by
quarter?
For example, on this other tab, I'd like to allow the user to select a
month, then have the spreadsheet autopopulate the quarterly info to-date
based on the month they selected...
So if the user selects the month April and JPY...in the first column it will
add together any JPY amount with a month less than or equal to March
(3)...and it column two it will add together any amounts with a month of
April (4)...and disregard anything beyond that.
Any ideas how I can do this? I can get the first QTR column to work with
the following formula...
=(IF($A$23,SUMPRODUCT(('Data 1st Half'!$B$4:$B$65000<=3)*('Data 1st
Half'!$E$4:$E$65000="JPY")*('Data 1st Half'!$G$4:$G$65000)),SUMPRODUCT(('Data
1st Half'!$B$4:$B$65000<=$A$2)*('Data 1st Half'!$E$4:$E$65000="JPY")*('Data
1st Half'!$G$4:$G$65000)))
But can't get this work for the periods 4, 5 & 6. Any ideas?