Problem description & analysis

Here is an Excel file Book1.xlsx:

Odd-numbered columns contain values and even-numbered columns contain names. We are trying to sum values for each name and output results beginning from, say, row 5, as shown below:

Solution & explanation

First, we load add-in ExcelRaq.xll and macro file esproc_template.xla to Excel, and then

Select cell A5 and enter the following formula in it: =esprocT("=?1.conj(~.group((#-1)\2)).groups(~(2);sum(~(1)))",A2:D3), press Ctrl+Enter, and drag A5 down to A6 to get results.

Q & A Collection

https://stackoverflow.com/questions/63588908/sum-up-numeric-lead-part-of-strings