I am trying to design a workbook so that when I enter an "R" or "L" in a
column on Sheet 1, the appropriate column with Category L or Category R in
Sheet 2 gets a 1 underneath it. Do you have any ideas about how might be the
best way to accomplish this?

Category Category L
Category R

R 1
1
R 1
1
L 1

L 1
L Total = 4
Total = 2
L

Sheet 1
Sheet 2