Excel 2003 on Windows XP

I am trying to write a macro using the conditional sum - however when I run
the macro nothing happens.

My goal is to count several produts in a column and put the results for each
one in another location. The best solution I could find to do this was the
conditional sum.

I should state that this Excel sheet is created each week and therefore
would need to work on the existing and plus all new sheets.

Any assistance greatly appreciated and let me know if any clarification is
needed.

Thanks

Francine