How do I create a simple table to sum up values

Question

Hi, can anyone help?&nbsp;&nbsp;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.&nbsp; So e.g. White Grape will equal 87% etc..&nbsp; 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?

rodrigo_ · Answer

Hello&nbsp;JamesC2485,Try this on E2, then copy paste it below.=SUMIF($A$2:$A$11,$D2,$B$2:$B$11)&nbsp;

oliverscheurich · Answer

JamesC2485&nbsp;=SUMPRODUCT(($A$2:$A$11=D2)*$B$2:$B$11)A simple alternative could be&nbsp;SUMPRODUCT.&nbsp;

jamesc2485 · Answer

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

jamesc2485 · Answer

Thanks for this, both work well

Forum Discussion

How do I create a simple table to sum up values

4 Replies

Resources