A helpful illustration: http://www.redcolony.com/pics/news/Space_elevator_structural_diagram.jpg

At the "climber", the net force is directed towards Earth, but smaller than normal gravity. At the center of mass/geosynchronous point, the net force is zero and you are weightless, and at the counterweight, you'd be flung outwards.