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.
