Bill,

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

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


--

HTH

RP

"Bill" wrote in message
...
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