Try

=SUMPRODUCT(--(Sheet1!$C$2:$C$100=$A2),INDIRECT(Sheet1!A$2:A$100 ))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"force530" wrote in message
...
I need a formula that will complete the data on a sheet 2 after being
entered
on sheet 1. The data to be entered is the amount in columns "Red & Blue"
and
the rows are are from a validation list which includes nuts, bolts,
screws,
and hammers.

Sheet 1
Red Blue Type
$5.00 $3.00 nuts
$3.00 $7.00 nuts
$5.00 $1.00 bolts
$6.00 hammers
$4.00 bolts
$8.00 screws
______________________________

Sheet 2
Red Blue
nuts
bolts
screws
hammers
TOTAL $ $