Is this summary going into a different sheet? How is the table laid
out in the summary? What cells are you using to hold the months,
products etc?

Try to give an example of what you want to end up with.

Hope this helps.

Pete

On Nov 12, 10:05*pm, Hank01061567
wrote:
Hi,

I have a monthly sales report and i am trying to determine how many
customers we have at the end of each month for the last few years so i can
attempt to display the growth of our penetration.

The spreadsheet has in column C the name of the client (each client is
allocated its own row), the date (month end) is in column P, the product type
is in column G.

so essentially what i want i want to do is sum the number of rows for each
month for each product.

Any help is greatly appreciated!

Thanks in advance.