Macro to automatically add column values when number of rows chang
 

New to VBA.
I have an Excel 2000 file that contains 3 columns with red,yellow,green
background fill which is not based on conditional formatting(manual). I want
to total the number of each color in each column. (columns C,D,E). I only
want certain rows in a rnage; not all rows.
The problem is the number of rows could change (adding or deleting rows).
The results of the counts I want to store in rows/columns at the bottom of
the sheet but the row location keeps changing.
The challenge is to pick a starting and ending row based on some criteria to
search for. I could put in a character in the row/column before and after to
determine the range.
I've looked at dynamic named ranges but it seems confusing to me.

Thanks,
--
Rick