Unique product total Count

[anupamfloyd]

I have a table like this , where products and number of sales each day is shown

Product	Sales
A	2
B	1
C	2
A	1
A	4
B	1
D	2

I would like to know how to get a cummulative total sales of each product. something like below for the above table.

Product	Sales
A	7
B	2
C	2
D	2

 

[SunnyAlv]

Like this ?

=LET(pd,B3:B9,sa,C3:C9,u,UNIQUE(pd),h,B2:C2,VSTACK(h,HSTACK(u,SUMIF(pd,u,sa))))

 

[anupamfloyd]

Like this ?

=LET(pd,B3:B9,sa,C3:C9,u,UNIQUE(pd),h,B2:C2,VSTACK(h,HSTACK(u,SUMIF(pd,u,sa))))

View attachment 112121

Thank you Works like a charm