Results 1 to 7 of 7

Transactions over a month broken down to each product type?

Threaded View

  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.

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