Totaling Quatnities with drop-down list.

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

Try in AG2:

Please Login or Register  to view this content.

Copy to other cells

Originally Posted by jakeisbill

This code works partially. It only seems to calculate for the First cell on the first day B3:D3.

Have you tried to change the date in upper-left of the result table? try to change to 1/1/2012 and see what happen

Originally Posted by jakeisbill

I see whats happening. Starting at AF1, the date there is the starting day for the week. My apologies.

OK, so you want to sum for the whole week?

So, in AG2 should be:

Please Login or Register  to view this content.

Confirmed with Ctrl-Shift-Enter

Originally Posted by jakeisbill

Sunglasses say nothing? can you mark this topic SOLVED?

i made a copy of your sheet and moved stuff around a bit. take a look and see if that is something you can work with? your profile indicated 2007 or later so i saved it as .xsls

then just keep entering the data downwards, it will become an easily-searchable data base. it wont matter what order the data is in. the way I organised it, is more like a database format