A force has both magnitude and direction. The net force on an object is the vector sum of the forces acting on it. Opposite forces cancel only when their magnitudes match; forces in the same direction add.
For a constant-mass object in ordinary Newtonian mechanics, a nonzero net force changes velocity. That change may involve speed, direction or both. Zero net force means no acceleration, not necessarily no movement: an object may continue moving at constant velocity.