How do I retrieve data for the last 90 days?
 

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

How do I retrieve data for the last 90 days?
 

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)




"Mark Barnard" wrote in message
...
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