past 7 day total

[lazor99]

Thanks in advance,

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.

 

[DominicB]

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]

Thanks

Hello Dominic,

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

 

[Aladin Akyurek]

Re: Thanks

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).