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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"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
>