Calculate total of only visible data.

[spidy]

I have attached a zip file of my actual data sample. First run the macro (a) macCreateDetailRpt and then (b) macFormatDetailRpt

The data is about the training given to employees of different company either web-based or via Instructor. The total field for each month gives the total number of students enrolled. The yellow color means that that company was given web based training in that particular month. Right now the Total Total column calculates the total of all the months. I want it to calculate only from the month the web-based training started. i.e Do a SUM of only the months the total is visible.

There is data in the months before the yellow month but it is just not visible. It will be visible when you highlight the whole row and then you can see that there is data in the Total field of each month.

Thanks for your help. If the explaniation is not enough please let me know.