Hi,
I am trying to create an assets spreadsheet.
On this spreadsheet (as attached) I want to sum accumulated depreciation of an asset based on the financial year selected in cell L1.
For example for asset in row 3, I want to sum amounts from P3:V3 for my selected year of 2023/24. I tried to a formula in cell L3 but it give me a #VALUE error, so will really appreciate of someone can help me with this.
Thanks
This:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Should be: =SUMIFS($P3:$AB3,$P$2:$AB$2,"<="&$L$1)
Thanks, but it sums the total for that asset. I would like the formula to calculate the accumulate depreciation for a up to a given year. So in my attached spreadsheet if my given year is 2020/21 (Cell L1) my calculation in cell L3 should be that total of P3:S3. I hope this makes sense.
=SUMIFS($P3:$AB3,$P$2:$AB$2,"<="&$L$1)
This works great. Thanks.
Ah, I misunderstood the requirement.
You may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks