I had a big problem to calculate on the groups of rows in excel file.
For long time, I did do it manually. Many times, I wrote my own specific program to take care of this problem.
That was a stupid way.
Excel2003, Ecel20007 can group the rows for you.
want to know how, click here:
From Microsoft : full story