Hi,
I have a large sheets containing 4700 rows of data with more the 700
unique code numbers.
I tried to use pivot table to get summary but it has limitations due to
which many code numbers are not displayed in the pivot tables.

Then, I tried to use sumproduct formula in cells but due to large
numbers of fumproduct formula, sheet became very slow.

So now I was trying to acheive the same results as of pivot table thru
VBA solution hoping that it might improve the performance.
Kindly let me know how to use the sumproduct formula in VBA.
My cell formula is as below.

=SUMPRODUCT(-(ALVXXL01!$B$2:$B$65536=A5),-(ALVXXL01!$K$2:$K$65536="MMV3"),(ALVXXL01!$P$2:$P$ 655360),ALVXXL01!$P$2:$P$65536)

If there is any better alternative, kindly let me know.

Thanks,
Madiya