Say it targets 3 foes to your right.
So if im at a table with 4 people (including myself) would the spell hit everyone? ie foe that is on my right, then the foe to his right and so on
Because once it gets around to the third foe he's technically sitting to my left (4 people Remember.)
Picture it as firing off to your right at each person until the spell peters out.
So you count to the right until you can't go anymore (i.e. reaching back to yourself), which does end up with the person on your left.