Calculate total of only visible data.

[spidy]

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

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

There is data in the months before the yellow month but it is just no
visible. It will be visible when you highlight the whole row and the
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 m
know

+-------------------------------------------------------------------
|Filename: sample.zip
|Download: http://www.excelforum.com/attachment.php?postid=3825
+-------------------------------------------------------------------

 

[spidy]

Bump for a reply. Please any suggestions any tips

 

[Ron Rosenfeld]

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.


+-------------------------------------------------------------------+
|Filename: sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3825 |
+-------------------------------------------------------------------+

Almost no one will download and run a file like this, especially one that
includes macros.

You'll be more likely to get an answer if you describe in text exactly what you
have, what data is available, and what you want to accomplish.


--ron