Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct by criteria, month, & year | Excel Worksheet Functions | |||
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
sumproduct for month and year | Excel Discussion (Misc queries) | |||
SumProduct or Array Function for summing by month and year | Excel Programming |