Results 1 to 6 of 6

Sum totals based on criteria

Threaded View

sss999 Sum totals based on criteria 06-27-2024, 09:20 AM
TMS Re: Sum totals based on... 06-27-2024, 09:35 AM
josephteh Re: Sum totals based on... 06-27-2024, 09:46 AM
sss999 Re: Sum totals based on... 06-27-2024, 09:48 AM
sss999 Re: Sum totals based on... 06-27-2024, 09:49 AM
TMS Re: Sum totals based on... 06-27-2024, 10:30 AM
  1. 06-27-2024, 09:20 AM #1
    sss999 is offline
    Registered User
    Join Date
    06-25-2020
    Location
    Peterborough, England
    MS-Off Ver
    Office 2016
    Posts
    5

    Sum totals based on criteria

    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting totals based on other columns criteria
    By NikkuSan7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2021, 03:07 PM
  2. Totals based on Criteria
    By yashagarwal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2017, 03:11 AM
  3. [SOLVED] Summing Totals Based on Criteria
    By robstark in forum Excel General
    Replies: 4
    Last Post: 02-10-2017, 02:01 AM
  4. [SOLVED] Adding up totals based on criteria from another column
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-07-2015, 09:02 PM
  5. How to sum totals in one table based on criteria from another
    By #Justin! in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 05:03 PM
  6. Running totals based on multiple criteria
    By smraines in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 05:10 PM
  7. Taking totals based on criteria. Is this possible?
    By BigBas in forum Excel General
    Replies: 4
    Last Post: 02-24-2007, 03:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1