Totaling Quatnities with drop-down list.

[jakeisbill]

Hello All, and Happy Holidays. Below I have attached a sheet for keeping track of the number of cables a person produces per day using Drop-Down list. I would like to have a totals area automatically calculate the corresponding cells. I could use several IF statements, but I think the resident Excel Ninja's on this forum could help with a smarter solution. I started the Totals area in column AF. Thanks in advance.

Cable Group.xls