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

D

dustin

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