Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following sumproduct formula that isn't working. Can someone help
me to fix it? It's the weeknum part that I can't get to work. =SUMPRODUCT(--(IF(WEEKNUM('Raw Data'!$M$2:$M$533,2)=WEEKNUM(N2,2),'Raw Data'!$M$2:$M$533)),('Raw Data'!$K$2:$K$533)) Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
sumproduct question | Excel Worksheet Functions |