I think its a sumproduct query?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
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.
.
Relevant Pages
- Re: iSight for sale
... to miss and it looks, at first sight, to be an ad for accessories, under ... "Bundle Offer" could easily have meant the bundle of the speaker dock, the mains charger and the cables. ... The format appeared to be a bullet list, with a heading of "Ipod 30GB" and "+" signs as the bullets, delimiting each of the items in the bundle. ...
(uk.adverts.computer) - Re: Function Wont Calculate -- Sometimes
... > knows to recalculate the function. ... I thought of that but I figured that it could cause a circular reference. ... Prev by Date: ...
(microsoft.public.excel.misc) - Re: OT: Sharing with the guys
... I'm heading out to Ted's house! ... Ray ... Prev by Date: ...
(alt.smokers.cigars) - new contract/tariff with loads of texts not 3
... SMS bolt ons seem a tad expensive: ... O2 havn't a clue - cannot find a text bundle on their site ... Prev by Date: ...
(uk.telecom.broadband) - Re: Morning Watch Smoke; September 22, 2005
... Loading up Mac Baren Navy Flake in a Cavicchi straight billiard and heading ... Rick Piatt ... Smoking Pipes since 1997 ... Prev by Date: ...
(alt.smokers.pipes) |
|
