Hi,

I was hoping to get some help on an extended version of this formula. The
spreadsheet I have records the quantity of e-mails answered each day and I'd
like to sum them by week. The formula below works perfectly for that,
however, the e-mails are for various programs.

I'd like to set up a table that contains a summary of quantity of e-mails by
program for a particular week. The table would have the program names listed
in cells L2:L5.

So, the current formula is
=SUMPRODUCT(--(1+INT(($A$2:$A$200-(DATE(YEAR($A$2:$A$200),1,2)-WEEKDAY(DATE(YEAR($A$2:$A$200),1,1))))/7)=1))

Where $A$2:$A$200 contains the various dates, how do I add to the formula
where $J$2:$J$200 contains the different program information?

Please let me know if any other details are required.

Thanks in advance,
Scott

"Bob Phillips" wrote:

=SUMPRODUCT(--(1+INT(($A$2:$A$200-(DATE(YEAR($A$2:$A$200),1,2)
-WEEKDAY(DATE(YEAR($A$2:$A$200),1,1))))/7)=1))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"jzingman" wrote in message
...
I've seen a few posts along this line, but I haven't figured out a good
solution. I want to sum by weeks of the year:

=sumif(weeknum(a1:a100), "=1", b1:b100)

But this doesn't work since you can't have weeknum there. I want this for
every week, and I'd like to make it more general, so I don't really want
to do

=sumif(a1:a100, "1/1/2007" AND < "1/8/2007", b1:b100)

for each week of the year.
Is there a general way to do this?

Thanks