Summing Number by Week and Month
 

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

Summing Number by Week and Month
 

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" 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

Summing Number by Week and Month
 

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


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

Summing Number by Week and Month
 

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