# Sumproduct from last week to first week of year

#### gustavoavila

##### New Member
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.

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

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

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### jamtay317

##### Well-known Member
what is your start and end day of the week? are you using excel 2010?

#### jamtay317

##### Well-known Member
Code:
``=IF(ISERROR((SUMPRODUCT((ProjectTable[Project]=[@Project])*(ProjectTable[Weeknum]=WEEKNUM(TODAY())-1)*(ProjectTable[Weeknum]>=(WEEKNUM(TODAY())-WEEKNUM(TODAY())+1);ProjectTable[@sales])``
try this

#### gustavoavila

##### New Member
Works perfect! Thank you!

Replies
0
Views
220
Replies
0
Views
315
Replies
0
Views
167
Replies
1
Views
151
Replies
0
Views
291

1,195,905
Messages
6,012,229
Members
441,683
Latest member
XLGeezer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back