I see a lot of posts here to do with sumproduct and I know how it works
(multiplying corresponding data in arrays and then summing the results) but
what practical applications does it have.

What situations would best be taken advantage of by using sumproduct?