I have exported all my monthly invoice details into excel where it shows
different products and different selling prices per unit for each invoice.
This report is relatively huge and I would like a summary that shows there
were 300 invoices for product X at selling price of $ 10, and 400 invoices
for the same product at selling price of $ 9...etc.
Is there any way that I can use Pivot Table or anything else to get my
desired summary report?

Thanks in advance

--
tarig

Hi,

The answer to your question is Yes, a pivot table should be able to do this.
Put the Product field in the Row area, the Price field in the Row area and
the Product field in the Data area.

We could be more specific if we saw a sample of the data. By the way when
you say the count of the $10 selling price for product X, does this mean
$10.00 or does it mean 10.00 to 10.99 or 10 to 19 or something else?

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Tarig" wrote:

I have exported all my monthly invoice details into excel where it shows
different products and different selling prices per unit for each invoice.
This report is relatively huge and I would like a summary that shows there
were 300 invoices for product X at selling price of $ 10, and 400 invoices
for the same product at selling price of $ 9...etc.
Is there any way that I can use Pivot Table or anything else to get my
desired summary report?

Thanks in advance

--
tarig