count of account by product

[Jaimee001]

Hi there,
I have an excel questions that I'm really racking my brains out over.
I have this report and I can filter it down to about 600 rows. the issue that some of the accounts use more than 1 product. I need to get a count of accounts and their products.
I used conditional formatting but that becomes tricky to count. I tried a pivot but there are so many rows and different products that it get's tricky to count as well

I've attached a mock up of a report. I did a couple of pivot table but still not sure how that would work

I'm not 100% well versed in the countifs formula but if that would work, please let me know. Also, would VB be a good alternative? sorry to keep rambling on but I don't know what to use.

Thank you in advance

 

[NARAYANK991]

Hi ,

What is important is your desired output format ; can we just have the products listed down the rows as well as across the columns , with the counts within this matrix ?

Secondly , is it possible that there will be 2 entries with the same account number and same product ID , but two different dates ?

Narayan