SUM of value, by looking at a number

[Hessing]

Solved!!!!

[ganeshkumar]

if u want to count the material number in ur sheet . just use the countif formula.

=countif(range,criteria)

[benishiryo]

hi Hessing. it's good if you can type out the desired answers you want to see next time. helps us be more confident we're on the right track. maybe:
=SUMIF(A2:A12,"0123",G2:G12)

that totals column G when column A is 0123.

[sktneer]

Or you can try this.......

=SUMPRODUCT(--($A$2:$A$12=A2),$G$2:$G$12)