excel formulas lookup sum multiple values

July 31, 2011 at 03:11:39
Specs: Windows 7

Office 2010 Excel

I have a table with code reference and value next to it I want to sum all the values with the same code reference.

2 100
3 70
2 20
2 200
5 10
83 233

The result should be: 100+20+200 = 320

thanks for the answers.

See More: excel formulas lookup sum multiple values

Report •

July 31, 2011 at 03:41:18
Look up the SUMIF function in the Excel Help files.

If you have any trouble figuring out how to use SUMIF, come on back and we'll see what else we can do to help you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question