Is it possible to create a formula that sums values in other rows based on a filter with the current row’s other column value?

For example, let’s say I have 3 columns:

- Topic (Primary Field)
- Owner: Person object (other table) or email address
- Score: Integer field

I want to calculate the sum of all Score fields where the Owner is the same.

From a table perspective, I was thinking about adding another column with a function like the following:

SELECT SUM(Score) WHERE Owner = this.Owner

This will result in the same value for all rows where Owner is the same, but I’m okay with that.

What’s the best way to accomplish something like this?