get a runing total for"curent date"or(cell)minus prev 30 days( cel

G

Guest

hello,
Im trying to figure out how to pull a running total for the
previous 30 days to the current date, and need it to change daily, i know i
might have to change the date everyday or a few small things, but Is there a
way to pick a cell and minus the numbers in the prveious 30 cells? and have
it auto change everyday??
 
B

Bob Phillips

Try this

=SUM(INDEX(A:A,MATCH(TODAY(),B:B,0)):INDEX(A:A,MAX(1,MATCH(TODAY(),B:B,0)-30
)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Rolling date looking 30 Days past 2
get a rolling sum between current date - 30 days 2
Exclude weekends when counting days only on day 29 or 30 3
Conditional Formating for dates beyond 30, 60, 90 to be high light 3
Running total over a find number of days 12
Figure out date from total days in year 2
Update a date into the same cell? 10
Adding days to a date cell to get a new date 6

Top