Try this:

=SUMIF(A1:A600,"Carpenter",C1:C600)

You could also enter the item to add into a particular cell, so that it
would be easily changed:

=SUMIF(A1:A600,D1,C1:C600)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Glenn" <Glenn@discussions.microsoft.com> wrote in message
news:C0FA5627-125A-49DA-B702-535E19BD3542@microsoft.com...
Hi all,
I have 2 columns A1:A600 & C1:C600
Column "A" contains a number of 'Validated List' drop boxes and Column "C"
contains values that depend on the list box selection
Q: If various boxes contained say "Carpenter" - How do I total the
resultant values of these from Column "C" to show the total value of all
"Carpenter" boxes??
Help