Drop Down Box Values - Excel 2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am having trouble turning a selection from a drop down box into a defined
value.

I am currently using a drop down box with 21 different options for people to
select. I would like to have these different options create a running total
on a different part of the ***. As an example I will use produce (since
this seems popular):

A1 B2 C2 D2
D3 D4

Purchase Date Customers One Apple Orange Grapes
Etc.
" " Customer Two " " " "
" " " "
" " Customer Three

The way I would like this sum to work is if Customer One purchases an Apple,
Orange, and Grape it will total it on another part of the *** with the
corresponding name like so:

Apple: 1
Oranges : 1
Grapes : 1

But also I need the functionability whereas Customer Two purchases only an
Apple and Orange it keeps the totals running respectively, i.e.:

Apple : 2
Oranges: 2
Grapes : 1

My goal for this is to know exactly how many Apples, Oranges, Grapes were
sold on a weekly basis to keep a running tally. Furthermore, lets say
Customer Three Purchases two Apples and nothing else but I want to make sure
that they only use one row under each customer so buying habits can be
tracked, i.e.:

A1 B2 C2 D2
D3 D4

Purchase Date Customers Three Apple Apple


Apple : 4
Oranges: 2
Grapes : 1

I understand that I could just put a column next to each possible drop down
box where the employee can place a "1" and just work from there but there is
21 different possibilities to calculate and it could make things more
difficult for the employee. I apologize for all the reading and any help
would be much appreciated!
.

Quantcast