Forum Discussion

JamesC2485's avatar
JamesC2485
Copper Contributor
Feb 10, 2023

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 n...
excel
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Feb 11, 2023

Hello JamesC2485,

Try this on E2, then copy paste it below.

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

 

  • JamesC2485's avatar
    JamesC2485
    Copper Contributor
    Feb 11, 2023

    Hi Rodrigo_ 

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

     

Resources