Which staff member has the most sales in this month?

Hi all,

If any of you Excel Whizz's could help me, I would really appreciate it.

A friend of mine imports sales data from an SQL database into an Excel spreadsheet - I don't know why he does this when he could just query SQL for his results, but he is set on finding out the information by importing it into Excel.

I think it needs an advanced formula to find out how many items each staff member sold in the month of April (or Mar, or May) and how much profit did he make? The bit that is lacking is how to total all the figures from a particular month for a particular person.

So essentially, he would like a summary table listing each person's total sales and profit made in each month sorted by year then month so that he can create graphs based on the year and month for each person.

Please help - thanks in advance.

Sharyn