Hello friends, I would like to request your assistance on the following matter; I do have a database with 5 years of information, the data has countries, Quantity Sold, the dates are in format mmyy ie

Aug-11), also contains products codes, and other attributes. What I need is to bring that information to another report. As you can see the months are in column, and I am going to write the report placing the months in one row, then having in the new report a column with the products code and the country where the products were sold an since the data contains hundred of transactions with one code at the same time throughout the whole database and years; I need to bring to each month in the new report the sum of all accumulated quantity sold in each country per code and per month of each year. This is not related to PIVOT TABLES or a simple VLOOKUP. This is a case to build a formula to index the months in my report to match it to the database, to find the country and code and then to sum all the records for that product code for each month and bring it to each cell on my new report. I WILL APPRECIATE ALL COMMENTS FOR GOOD. THANKS A LOT.
| | Apr-11 | May-11 | Jun-11 | Jul-11 | Aug-11 | Sep-11 | Oct-11 | Nov-11 | Dec-11 | Jan-12 | Feb-12 | Mar-12 | Apr-12 | May-12 |
Code | Country | Formulas must be here to bring the numbers from the database. | | | | | | | | | | | | | |
The database I put only one month per year. The reality is that this is a database with 500K rows the smallest one. | | | | | | | | | | | | | | | |