Hi,

Could someone please give me some suggestions for how to do the following:

I have a table that summarizes all of my past sales data for each of my
reps. The columns look like this:

RepNum Product State Months (1) Months (2)... Months (12) Total
20 XYZ NM $150 $700 .... $50
Sum(Months)
20 XYZ AZ $200 $900 .... $100
20 XYZ NV $150 $0 .... $0
....

The problem is that there are some entries that were mistakes because a
particular sales rep doesn't sell in a certain state. In the example above,
rep 20 doesn't really sell in NV so that $150 are a faulty entry and so I
want the total column to show $0 and not $150.

I have a table named repStates that lists the Rep Number (multiple times) on
each row of the first column and then lists all of the States in the second
column (one to each row). The table looks like this:

RepNum STATE
20 AZ
20 NM
30 NY
30 NJ
....

Any ideas for how to use excel to do what I am trying would be hugely
appreciated.

Thanks,
Michael