Results 1 to 8 of 8

Finding, Counting, and Summing Multiple Variables in a Data Table

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Finding, Counting, and Summing Multiple Variables in a Data Table

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1