Taking totals based on criteria. Is this possible?

This should work;

paste these formulas starting in Sheet2 B3

=INDEX(Sheet1!$K$3:$K$14,MATCH(A3,Sheet1!$A$3:$A$14,FALSE),MATCH($B$1,Sheet1!$A$2,FALSE))
=INDEX(Sheet1!$K$3:$K$14,MATCH(A4,Sheet1!$A$3:$A$14,FALSE),MATCH($B$1,Sheet1!$A$2,FALSE))
=INDEX(Sheet1!$K$3:$K$14,MATCH(A5,Sheet1!$A$3:$A$14,FALSE),MATCH($B$1,Sheet1!$A$2,FALSE))
=INDEX(Sheet1!$K$3:$K$14,MATCH(A6,Sheet1!$A$3:$A$14,FALSE),MATCH($B$1,Sheet1!$A$2,FALSE))
=INDEX(Sheet1!$K$3:$K$14,MATCH(A7,Sheet1!$A$3:$A$14,FALSE),MATCH($B$1,Sheet1!$A$2,FALSE))
=INDEX(Sheet1!$K$3:$K$14,MATCH(A8,Sheet1!$A$3:$A$14,FALSE),MATCH($B$1,Sheet1!$A$2,FALSE))

Hi,

With the structure of sheet1, use following offset formula, in sheet2 cell B3:

=OFFSET(Sheet1!$K$3,14*(COLUMN()-2)+ROW()+ROW()-6,0)

Glad it fixed your problem ...

Thanks for the feedback