I have a sheet that looks something like this:
A B C D
1 Brand Dealer Type Amount
2 Lesli HD Cake 2
3 Rubro PL Cake 1
4 Zena PL SS 3
5 Zena HD Cake 2
6 Rubro PL SS 12
Totall Cakes HD: 4
Totall Cakes PL: 1
Totall SS HD: 0
Totall SS PL: 15
This is not a Pivot Table
What I want is to know the total amount of a specific type of a specific dealer. So in this example: the totall amount of cakes from dealer "HD" is 4. What formula can I use for this?
A B C D
1 Brand Dealer Type Amount
2 Lesli HD Cake 2
3 Rubro PL Cake 1
4 Zena PL SS 3
5 Zena HD Cake 2
6 Rubro PL SS 12
Totall Cakes HD: 4
Totall Cakes PL: 1
Totall SS HD: 0
Totall SS PL: 15
This is not a Pivot Table
What I want is to know the total amount of a specific type of a specific dealer. So in this example: the totall amount of cakes from dealer "HD" is 4. What formula can I use for this?