Additional help with Sumproducts

To start with, as was highlighted on your other thread, to do the Summation you need not use a Sumproduct, a standard SUMIF will suffice and will be quicker:

=SUMIF(Worksheet1!$A$1:$A$6,"*7",Worksheet1!$B$1:$B$6)

If you want do extraction of entire records I would strongly advise you add a column to Worksheet 1 that extracts the last char, eg:

Worksheet1!C1: =RIGHT($A1,1)
copied down to C6

Then use a Pivot Table with Range A1:C6, Column C as your PAGE Field, Column A as your ROW field and Column B as your DATA Field.

First, enter this formula in Sheet2, say cell A1:

Please Login or Register  to view this content.

Then use this formula to extract the relevant data:

Please Login or Register  to view this content.

which you must confirm with CTRL+SHIFT+ENTER not just ENTER, then copy over 1 column and down as far as you want to extract all data.

If you adjust ranges, you need to reconfirm with CTRL+SHIFT+ENTER before copying across and down again