In A1:C2 I have:

CC Method1 Method2
01016000 4,263.00 4,263.00

Cell B2 contains:

=SUMPRODUCT((LookUpTable!$B$7:$B$12=Summary!A2)*(L ookUpTable!$C$7:$G$12))

Cell C2 contains:

{=SUM((LookUpTable!$B$7:$B$12=Summary!A2)*LookUpTa ble!$C$7:$G$12)}

Both Methods work fine; I'd just like to have another 1 or 2 methods
of obtaining the same answer. Any suggestions?

Here is my $B$7:$B$12 on LookupTable:

01016000 3,245.00 43.00 432.00 543.00
01016100 456.00 567.00 543.00
01016200 654.00 654.00
01016300 654.00 543.00 567.00
01016400 3,458.00 456.00 7,323.00
01016500 6,788.00 567.00

Thanks in Advance..