New Contributor

# How do I create a simple table to sum up values

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?

4 Replies

# Re: How do I create a simple table to sum up values

Hello @JamesC2485,

Try this on E2, then copy paste it below.

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

# Re: How do I create a simple table to sum up values

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

# Re: How do I create a simple table to sum up values

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

A simple alternative could be SUMPRODUCT.

# Re: How do I create a simple table to sum up values

Thanks for this, both work well