Candace:

The idea is to have one formula that will work for all rows when the range is expanded. You put that formula in the collapsed row and then it is copied to every row created when you expanded the statement.

If you don't fully understand how the expand/collapse process works then it's going to be difficult to help you in this forum. You may want to contact your Adagio dealer for some training.