MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I automatically add the last 30 days of a row?


Posted by Frank on November 13, 2001 8:33 PM

I have a spreadsheet that needs to add the last 30 days of a row. How can I set it up to automatically add the contents of the cells of the last 30 days? It needs to automatically update on a daily basis and give the sum of only the last 30 days.


Posted by IML on November 14, 2001 7:57 AM

With Dates in A and what you want to sum in B, you could use

=SUMIF(A1:A41," > "&TODAY()-30,B1:B41)

I've added to unnecessary spaces aroung the greater sign in hopes this will post properly. You may need to delete them if you paste this formula in.