If you can write an Excel formula, you can build your own function.
Pivot tables still have their place, but I'd rather type one formula for a quick summary.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results