SumProduct by specific weeks of the month or year

B

BLUV

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumProduct by specific week in a month 8
counting weeks in current month. 1
allocate resource over long period of time 0
Month of year in code 2
SOS-Need to calculate number of working hours per each week of mon 2
sumproduct problem (another one) 3
sumproduct by year 2
HELP WITH SUMPRODUCT FORMULA USING YEAR() and MONTH() FUNCTIONS 5

Top