Excel 2007 : calculating sales won in a week

[Niven Howlett]

Newbie here so go easy please

I run a sales team and want to analyse sales per week better.

I have a Sales Won spreadsheet with 3 columns:
Column A is the week number (1-52)
Column B is the sales person
Column C is the client Company name
Column D is the order value
Each sale is entered on a new row with the above detail in each column

I want to create another table that will show the value of all sales won in a specific week.

Can anyone suggest something?

many thanks

[shg]

Welcome to the forum, Niven.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[Niven Howlett]

I changed the title, is that better? I was excited to have received a reply so quickly

[shg]

Better, thank you.

Post a sanitized workbook that shows what you want and someone will help.

[suzzy]

Hi Niven Howlett,

There is a Sales Dashboard I know and would highly recommend you to take a look at. This dashboard provides the analyses for revenues by industry, region, product and sales representative. Considering your requirements, I think you can give it a try and see if it helps:

http://www.spreadsheetzone.com/templateview.aspx?i=38

[Niven Howlett]

Better, thank you.

Post a sanitized workbook that shows what you want and someone will help.

sanitized?

[DonkeyOte]

ie - ensure the sample file contains nothing confidential - dummy names, values etc...