How do I create a simple table to sum up values

[JamesC2485]

Hi, can anyone help?

 I thought this should be simple but no.. Anyway, I have multiple tables like the one in the image with several rows that have the same "Type". Each row has a % and I need to create a simple table in column D and E.  So e.g. White Grape will equal 87% etc..  Pivot Tables won't be an option has I have about 50 of these to do on one sheet! . Is there a simple formula I can use to do this?

[#2]

Hello @JamesC2485,

Try this on E2, then copy paste it below.

=SUMIF($A$2:$A$11,$D2,$B$2:$B$11)

 

[#3]

Hi @Rr_ 

Thanks for this, that works. I had a feeling it was to do with SUMIF but had no idea on the formula! Thank you

[#4]

@JamesC2485 

=SUMPRODUCT(($A$2:$A$11=D2)*$B$2:$B$11)

A simple alternative could be SUMPRODUCT.
 

[#5]

Thanks for this, both work well