Total sales dollars last 7 days, sumifs

dues99

I am trying to get a formula to tell me that total amount of sales for the last 7 days.

Currently I have:

=SUMIFS([ESTIMATED REVENUE]:[ESTIMATED REVENUE], <=today(-7), Date Released:Date Released)

I have tried modifying it several times with no luck...

 

Thanks,

Kyle

 

Andrée Starå

Hi Kyle,

Try something like this.

=SUMIFS([ESTIMATED REVENUE]:[ESTIMATED REVENUE]; [Date Released]:[Date Released]; >=TODAY(-7))

The same version but with the below changes for your and others convenience.

=SUMIFS([ESTIMATED REVENUE]:[ESTIMATED REVENUE], [Date Released]:[Date Released], >=TODAY(-7))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

dues99

=SUMIFS([ESTIMATED REVENUE]:[ESTIMATED REVENUE], [Date Released]:[Date Released], >=TODAY(-7))

This one worked!  

Thanks!

 

Andrée Starå

Excellent!

Happy to help!