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

=IF($a1MAX(OFFSET(Sheet1!F$2,126*(ROW()-1),0,5,1)),"buy","")