Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I think its a sumproduct query?
Top of the day to you,
I have a list of dates over several years (A column) Debts accrued during those years (B Column) I'd like to sum the total debts over a specific period of years from the current year, under its respective heading, i.e. debts accrued 1-3 years from the current year, 4-5yrs, 6-10yrs etc. I'd need it to remain fairly dynamic that next and following years it will recalculate from the new year. Thanks a bundle. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
Web Query Help... | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Excel2000 ODBC query oddity | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |