I have attached a spreadsheet to my thread. I have several questions I need help on. Here is a summary on the information I would like to find.
I want to be able to find how many quotes I have received in a particular month and how many quotes I completed in a particular month. However, I need a breakdown of quotes that were completed during the month that were received during that month and other months.
Essentially, I would like an output that provided the following information:
INPUTS
Month: July
Year: 2010
OUTPUTS
Quotes:
Total monthly received quotes:
Quotes completed from May start date:
Quotes completed from June start date:
Quotes completed from July start date:
Sales
Total monthly sales:
Sales completed from May start date:
Sales completed from June start date:
Saless completed from July start date:
From that information I would like a breakdown of companies who bought from a quote and how many times they did.
I would eventually like to add graphs to give a visual representation as well.
Please view the following attachment for a better understanding. Any help is appreciated.
Thank you.
Bookmarks