Hey there
So I ran this myself and it seems to confirm what you are saying.
In summary: when you sum on a lookup field it works. When you sum on a lookup field that looks up another lookup field, sum does not work anymore.
That’s very interesting.
@nigel do you know if this is a bug?