sheet 2 total1 = sum of sheet1 cell d2 if sheet1 cell b2 = sheet1 cell c2; plus
sum of sheet1 cell d3 if sheet1 cell b3 = sheet1
cell c3; plus
the d2, b2, c2 cells go up to 30 or 40, but the total is the sum of all of
the equals using the number in the c2 thru c30 or c40 cells. example follows:
B C D

XY XY 5
CD SD 21
22 22 10
TOTAL1 = 15 BECAUSE XY=XY AND 22=22. And there can be 30 to 50 columns.