+ Reply to Thread
Results 1 to 7 of 7

Transactions over a month broken down to each product type?

  1. #1
    Registered User
    Join Date
    12-03-2003
    Posts
    16

    Transactions over a month broken down to each product type?

    I have a set of sales data which shows the dates of transactions and also the product type that was sold. I want to see the monthly sales for each product type. I can get a total for all product types over the months using the following:

    =COUNTIF(Licences!E2:E9999, "<39600")-COUNTIF(Licences!E2:E9999,"<39569")

    36900 = Jun-08
    39569 = May-08

    But I need it to also break it down for product a, b, c so I need something else to add to the formula?

    Thanks in advance
    Last edited by Simon L; 04-27-2009 at 11:38 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Transactions over a month broken down to each product type?

    Something like this?

    Book1.xlsx

    Edit: If you need only to count them you can remove F5:F19 from formula

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,114

    Re: Transactions over a month broken down to each product type?

    Sounds like you should try using a Pivot table
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    12-03-2003
    Posts
    16

    Re: Transactions over a month broken down to each product type?

    Quote Originally Posted by zbor View Post
    Something like this?

    Attachment 42218

    Edit: If you need only to count them you can remove F5:F19 from formula
    I don't understand how this would work for me because I want to count results between a date range i.e. 1 April 09 to 30 April 09 ??

  5. #5
    Forum Contributor
    Join Date
    04-16-2009
    Location
    Stellenbosch, South Africa
    MS-Off Ver
    Excel 2003; Excel 2007; Excel 2010; Excel 2013
    Posts
    136

    Re: Transactions over a month broken down to each product type?

    What column is your product held in? Let's assume column D:

    =SUMPRODUCT(--(D2:D9999=Product),--(E2:E9999>StartDate),--(E2:E9999<EndDate))

    Change Product, StartDate and EndDate to cell references.
    Regards

    Jon (Excel 2003, 2007, 2010, 2013)

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Transactions over a month broken down to each product type?

    Then you need to add start and end date

    Book1(1).xls

  7. #7
    Registered User
    Join Date
    12-03-2003
    Posts
    16

    Re: Transactions over a month broken down to each product type?

    Quote Originally Posted by zbor View Post
    Then you need to add start and end date

    Attachment 42225
    thanks that sorted it out.

+ 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