View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BLUV BLUV is offline
external usenet poster
 
Posts: 15
Default SumProduct by specific weeks of the month or year

Hi everyone,
I been able to sucessfully find the number or projects my team has worked
per month by using the following calculation (example is for August only):

=SUMPRODUCT((--(MONTH(StatsCount)=8))*(StatsProduct=BD3))

Now I'd like to take it to the next level by find the number of projects my
team has worked on per week, week after week, for the entire year. My team
works 7 days a week not 5 and this calculation help them determine where to
bill their time at the end of each week. Can you help me break down the
above formula to give me weekly results?

--
RyGuy