| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total last 30 days
I have dates in column A
Numbers in column B I want to find the sum of numbers on column B that correspond to the last 30 days (including today), 90 days, 6 months, 1 year. I used =SUMIF(A:A,(TODAY()-30),B:B)+SUMIF(A:A,(TODAY()-29),B:B)+SUMIF(A:A,(TODAY()-28),B:B)... etc. until I got 30 days. Q? Is there an easier formula/method? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total of hours based on last 7 days | Excel Worksheet Functions | |||
| get a runing total for"curent date"or(cell)minus prev 30 days( cel | Excel Worksheet Functions | |||
| total a time column that is formatted as ddd:hh:mm:ss .ddd=days | Excel Worksheet Functions | |||
| how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
| running total for last 7 calender days | Excel Discussion (Misc queries) | |||
Threaded Mode
