I was wondering if anyone could help me figure out this problem. In one sheet I have a list of totals that are every 6 rows. I would like to make a rolling total on the next sheet. For example, Sheet2!A1=Sheet1!A1, Sheet2!A2=Sheet1!A8+Sheet2!A1 and so on. Some one please help me with this problem.