Sumproduct from last week to first week of year

[gustavoavila]

Hi folks,

I'm trying to create a formula to compare total sales and sales until last week.

I've create this formula, but, only gives me the sales of the las week but I need the total sales until last week. Do you have any idea? I'm uploading an example to be more specific.

=IF(ISERROR((SUMPRODUCT((ProjectTable[Project]=[@Project])*(ProjectTable[Weeknum]=WEEKNUM(TODAY())-1);ProjectTable[@sales])

Example file: https://mega.co.nz/#!u4wzELJD!Gs3JnUJFHL9QShJW0z-zYW9ExTArVE8tMdkWWp3eEqM

Thanks in advance.

 

[jamtay317]

what is your start and end day of the week? are you using excel 2010?

 

[jamtay317]

=IF(ISERROR((SUMPRODUCT((ProjectTable[Project]=[@Project])*(ProjectTable[Weeknum]=WEEKNUM(TODAY())-1)*(ProjectTable[Weeknum]>=(WEEKNUM(TODAY())-WEEKNUM(TODAY())+1);ProjectTable[@sales])

try this

 

[gustavoavila]

Works perfect! Thank you!