# Offset in Formula

G

#### Guest

Sheet1
Has the following Information
Col A row 1-50 aaa in each cell
Col B row 1-50 different numbers
Col A row 51-100 aab in each cell
Col B row 51-100 different numbers
Col A row 51-100 aac in each cell
Col B row 101-150 different numbers
Sheet 2
a1 AAA

This is the formual I have been trying but it does not work

a2 aab
a3 aac
In Col b 1 Would like to see the sum of aaa rows 1-5
IN col c 1 Would like to see the sum of aaa rows 6-30
in col d 1 Would like to see the sum of aaa rows 31-50

In Col b 2 Would like to see the sum of aab rows 51-55
IN col c 2 Would like to see the sum of aab rows 56-80
in col d 2 Would like to see the sum of aab rows 81-100

In Col b 3 Would like to see the sum of aac rows 101-105
IN col c 3 Would like to see the sum of aac rows 106-130
in col d 3 Would like to see the sum of aac rows 131-150

G

#### Guest

sheet2
Cell B1: =sumif(sheet1!A1:A5,A1,sheet1!B1:B5)
Cell C1: =sumif(sheet1!A6:A30,A1,sheet1!B6:B30)
Cell D1: =sumif(sheet1!A31:A50,A1,sheet1!B31:B50)
Cell B2: =sumif(sheet1!A51:A55,A2,sheet1!B51:B55)
Cell C2: =sumif(sheet1!A56:A80,A2,sheet1!B56:B80)
Cell D2: =sumif(sheet1!A81:A100,A2,sheet1!B81:B100)
Cell B3: =sumif(sheet1!A101:A105,A3,sheet1!B101:B105)
Cell C3: =sumif(sheet1!A106:A130,A3,sheet1!B106:B130)
Cell D3: =sumif(sheet1!A131:A150,A3,sheet1!B131:B150)

good luck