+ Reply to Thread
Results 1 to 2 of 2

Making a chart calculate quantities

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    Pennsylvania
    Posts
    4

    Making a chart calculate quantities

    Question:

    How do I Calculate the amount of data in a column that is within a certain range, and then chart it?

    Situation:

    Column C lists times of day an order was processed(i.e. , 11:00a, 1:30p, 1:33p, 1:33p, 2:00p,2:30 pm...etc.)
    I need a chart that shows that between 11 & 12 there was 1 order processed; between 1 and 2 pm we had 3 orders processed and between 2 and 3 there were 2 orders.

    I cant get excel to calculate the number of entries between two ranges.

    As always any help is appreciated

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Making a chart calculate quantities

    You can use countif or sumproduct to do this. Post a workbook if you need more detail.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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