repost: conditional sum?
 

Using subtotal

Fruit Qte
Apple 12
Total Apple 12
Banana 53
Total Banana 53
grape 43
grape 88
Total grape 131
grape 6
Total grape 6
Orange 52
Orange 51
Total Orange 103
Total 305



Using Pivot Table
Sum of Qte
Fruit Total
Apple 12
Banana 53
grape 131
grape 6
Orange 103
Total 305



Yipeee