Since it is often useful in DSP (filters, Fourier transforms of flat windows), let us derive the finite sum of geometric series again: $$s_{p,q} = \sum_{k=p}^q a^k\,. $$
with $a\neq1$ and $p\le q $. The trick here is that the sum is almost the same if you factorize some integer power of $a$ (a kind of scale invariance), only the first and the last terms change:
$$s_{p,q} = a^p + \sum_{k=p+1}^{q+1} a^k - a^{q+1} = a^p - a^{q+1} + a\sum_{k=p}^{q} a^k \,, $$
hence $$s_{p,q} -a s_{p,q} = a^p - a^{q+1}\,. $$
or
$$s_{p,q} = \frac{a^p - a^{q+1}}{1-a} = a^p\frac{1 - a^{q+1-p}}{1-a} \,. $$
So whenever $p-q+1$ is a multiple of $N$, and $a=e^{-j2\pi/N}$, the sum $s_{p,q}$ vanishes to zero. However, the visual proof of Markus is way better. I will thus add another geometrical proof, also based on the concept of invariance: the complex roots of unity define a regular polygon. This polygon is invariant by a rotation of angle $2\pi/N$, so the sum $s$ of the original vertices is the same as the sum of the vertices rotated, which is $s\times e^{-j2\pi/N}$. And therefore
$$s = s\times e^{-j2\pi/N}$$
which has only one solution: $s=0$.