View Single Post
  #2   Report Post  
Rob van Gelder
 
Posts: n/a
Default

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

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


"Glenn" wrote in message
...
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