Total the duplicated

[ginchuan]

i try to vlookup usage at sheet1 to page 1,but i were have few item is duplicated, is that can total all the usage for the duplicated item？

Look.xlsm

[Ace_XL]

In C2
=SUMIF(Sheet1!$B:$B,$B2,Sheet1!C:C)

Copy down and across

In Sheet1 your values are text. Do this to convert to numbers
- In a separate cell input 1
- Copy this cell
- Select range
- Paste special -- Multiply
- Ok