Suggestions for totaling columns, first by a category, then in total

[KimWalton_ncf]

Looking for suggestions on totaling columns in this spreadsheet.  The data is a large number of amortization schedules (inconsistent payments so not using a template).  These need to be summarized first by the noteholder and then in total. In total there will be 3 noteholders and about 40 notes.

Version: O365 Version 2204

[#2 · Accepted solution]

The solution found uses the sumproduct function.