Hi,

I have a formula set up to count the number of e-mails answered by category
for each month. The formula being used is:

=SUMPRODUCT(--(MONTH(Pivot!$E$8:$E$1589)=MONTH($B$1)),--(Pivot!$E$8:$E$1589<>"")*(Pivot!$J$8:$J$1589=A24))

Where column E contains the date the e-mail was answered; Cell B1 contains
the date I'm checking and column J contains the category assigned to the
e-mail and cell A24 is the category I'm trying to get the end result for.

I'd like to do the same thing but calculate it by week. I was feeling
rather confident and just substituted "WEEKNUM" for "MONTH" to have:

=SUMPRODUCT(--(WEEKNUM(Pivot!$E$8:$E$1589)=WEEKNUM($B$1)),--(Pivot!$E$8:$E$1589<>"")*(Pivot!$J$8:$J$1589=A24))

But I get a result of: #VALUE!

Can somebody offer advice on where I've gone wrong?


Thanks in advance,
Scott