ExcelBanter - SumProduct Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SumProduct Question (https://www.excelbanter.com/excel-worksheet-functions/106752-sumproduct-question.html)

SumProduct Question

My data table looks like this:

BOXID 60103 60101 60622 60626
BOX005 0.00% 30.51% 0.00% 0.00%
BOX009 0.05% 0.53% 0.01% 0.00%
BOX017 16.31% 14.20% 19.71% 23.34%
BOX050 0.19% 0.02% 1.92% 0.88%
BOX060 0.00% 0.00% 0.00% 0.00%
BOX074 0.00% 0.00% 0.00% 0.00%

I am trying to find a formula that will give the average of the data
relating to the BOXID and the 2nd and 3rd characters of row 1 of the data
table. The result would be like this for example.

1 2 6
BOX005 15.25% 0.00% 0.00%
BOX017 15.25% 0.00% 21.52%

Thank you in advance.

SumProduct Question

See your later post.

Biff

"carl" wrote in message
...
My data table looks like this:

BOXID 60103 60101 60622 60626
BOX005 0.00% 30.51% 0.00% 0.00%
BOX009 0.05% 0.53% 0.01% 0.00%
BOX017 16.31% 14.20% 19.71% 23.34%
BOX050 0.19% 0.02% 1.92% 0.88%
BOX060 0.00% 0.00% 0.00% 0.00%
BOX074 0.00% 0.00% 0.00% 0.00%

I am trying to find a formula that will give the average of the data
relating to the BOXID and the 2nd and 3rd characters of row 1 of the data
table. The result would be like this for example.

1 2 6
BOX005 15.25% 0.00% 0.00%
BOX017 15.25% 0.00% 21.52%

Thank you in advance.