Summing Number by Week and Month

[Bill]

Hello,
I have a file that contains reasons for errors in a process. Each row is
one error and contains info such as date, reason for error, etc. I would
like to be able to sum the number that occur per week and per month using
VBA code. Is there an easy way to do this? I have done it by adding a week
number, month number and year number and summing, but that seems a little
long winded.

Thanks.

Bill

 

[Tim]

does it need to be done via VBA? i'm sure i've done something similar using
a pivot table from the <Data> menu button (which i guess could be refreshed
evey time it is acessed)

 

[Bill]

Thanks Tim. I would prefer doing it VBA code, if possible. But a Pivot
Table would probably be better than what I have now.

Bill

 

[Bob Phillips]

Bill,

If you want VBA, you can utilise SUMPRODUCT function from within VBA, such
as

myNum = Evaluate("SUMPRODUCT(--(TEXT(A1:A20,""mmm"")=""Oct""))")