# Transactions over a month broken down to each product type?

1. ## 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?

2. ## 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. ## Re: Transactions over a month broken down to each product type?

Sounds like you should try using a Pivot table

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

Originally Posted by zbor
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. ## 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.

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

Then you need to add start and end date

Book1(1).xls

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

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

Attachment 42225
thanks that sorted it out.

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

#### 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