# past 7 day total

#### lazor99

##### Board Regular

Looking to track yesterdays total & past 7 days total on monthly sales number totals. Sales numbers are inputed daily on sheet 1 and summary is on sheet 2. yesterdays total is in A1 and past 7 days is in A2

thanks again.

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### DominicB

##### Well-known Member
Good afternoon lazor99

You need to make your posts a bit clearer. If I'm reading it right you want a formula that will automatically add up the last 7 days sales (ie., without you intervening). If so use this formula:

=SUM(IF(\$D\$2:\$D\$14>(NOW()-7),\$E\$2:\$E\$14,0))

This assumes you have dates in column D and values in E.

It's also an array formula so use shift + ctrl + ener to commit.

HTH

DominicB

#### lazor99

##### Board Regular
Thanks

Hello Dominic,

Yes you did read me right and i thank you very much.

##### MrExcel MVP
Re: Thanks

lazor99 said:
Hello Dominic,

Yes you did read me right and i thank you very much.

If so, then:

=SUMIF(\$D\$2:\$D\$14, ">"&TODAY()-7,\$E\$2:\$E\$14)

will suffice (confirmed with just enter).

Replies
8
Views
178
Replies
9
Views
241
Replies
4
Views
103
Replies
3
Views
189
Replies
0
Views
399

1,195,680
Messages
6,011,122
Members
441,586
Latest member
rodsin76

### 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