How do I retrieve data for the last 90 days?

  • Thread starter Thread starter Mark Barnard
  • Start date Start date
M

Mark Barnard

I want Excel to "look back" over the previous 90 days and give me a total of
the data. For example, I record my sales each day. I want to display the
running total of sales for the past 90 days.

Thanks to anyone who has any ideas.

Respectfully,

Mark Barnard
(e-mail address removed)
 
If your dates are in A1:A10 and the values to sum are in B1:B10, use a
formula like


=SUMPRODUCT((A1:A10>=TODAY()-90)*B1:B10)


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum for last 90 days 3
How do I set caps lock as default? 1
VBA - retrieve data on last create named range from previous inserted named range 0
how to convert COUNTIF() into VBA macro 0
Urgent Help needed!!!! 3
How do I auto complete a cell with text from another worksheet? 3
Retrieve Column Header for Specific Data in a Row 3
Changing the colour of a cell after a specific date? 0

Back
Top