Just realised that I posted this topic in the Excel 2007 forum when it will probably need to go in this one. Apologies. If a mod needs to delete the other topic feel free to do so.

I am having some difficult on Excel with creating a spreadsheet that will add up commission for certain dates.

Allow me to explain in detail. Firstly, I have created a spreadsheet that will accumulate the data whereby details are placed from left to right giving details about the product just sold (date sold, commission, etc). Each person has a specific workbook on the collection spreadsheet so they are quite clearly sperated.

What I want to do is create a new excel document (not accessible to the sellers that input the data on the aformentioned spreadsheet) that will calculate commission on certain days. How I want it to work (if possible) is to enter the date you want the total commission data for and it will find all the corresponding data in the table that match up to that date and will give me a total for each person (again to reiterate, just a total for the specific - typed in - date)

I do not want it to add up all the commission in the table as there will be data in for all days of the month.

Can anyone help with the best way to approach this? Thanks