Hey BIRD, there's been another change in the plan. I wish my Supervisor would just make up their minds how they want this done, so that I can be done with it. So here's the problem

They want a formula that will total on which officer has pend in on cell and which officer has techs in another.

example: officer joe has 12 tech and 20 pending
officer john has 20 tech and 10 pending
officer doe has 50 tech and 20 pending

SHEET#1
colm #A will be officer name, colm #B will have the word tech or pend beside the officer row that the data is enter. On SHEET#2 the STATS will refect the total # of tech and a total # of pend for each officer.