Transactions over a month broken down to each product type?

**Simon L** · 04-27-2009, 07:12 AM

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

**zbor** · 04-27-2009, 07:19 AM

Something like this?

Book1.xlsx

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

**Andy Pope** · 04-27-2009, 07:35 AM

Sounds like you should try using a Pivot table

**Simon L** · 04-27-2009, 08:40 AM

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

**JONvdHeyden** · 04-27-2009, 08:48 AM

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.

**zbor** · 04-27-2009, 08:48 AM

Then you need to add start and end date

Book1(1).xls

**Simon L** · 04-27-2009, 11:34 AM

Originally Posted by zbor

Then you need to add start and end date

Attachment 42225

thanks that sorted it out.

Transactions over a month broken down to each product type?

LinkBack

Thread Tools

Rate This Thread

Display

Transactions over a month broken down to each product type?

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions