send me some actual sample data in a workbook and color the cells where you
want a subtotal in blue and the cells to subtotal in red.

Indicate in green where you want the summary of the subtotals.



--
Regards,
Tom Ogilvy


" wrote:

Well, I could not get to the answer that I needed using the above
advice so I thought I would try a differenct tactic.

I need to sum a range of #'s that will vary in size. I would want the
macro to find the Yes in Col. B and then, move down to the Col. D
(ignoring the subtotals from the Col. C categories) subcategories
(contract labor, etc.) and sum up these lines for 12 columns (12
months). I would then, need to skip other the second category (Expense
Ongoing) and sum up the subcategories (equip. depr, etc.)

Any ideas?