Doing it in the Excel is the simplest option.
Though you can use Series support in PractiScore app for Android to bring all the data together, then export and then open the html report in Excel to do your calculations.
On a side note, the said “series” support allows to use other “series” as part of the series results.
E.g. you can create separate series for locations A and B (with best 1 match result). But I can’t think of a way to exclude matches from these series from the 3rd “another score from any location”.