+ Reply to Thread
Results 1 to 3 of 3

Calculate total amount based on given year

  1. 03-16-2022, 02:05 PM #1
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Exclamation Calculate total amount based on given year

    Hi Guys,

    I would like to calculate the total amount based on the year and average interest rate given in L27.

    I tried this formula but it does not work for me.

    =SUMIFS($E$27:$E$506,$B$27:$B$506,">"&DATE(L27,1,1),$E$27:$E$506,"<"&DATE(L27,12,31))

    Thank you for your help.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-16-2022, 02:43 PM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Calculate total amount based on given year

    Please try

    =AVERAGEIFS($C$27:$C$506,$B$27:$B$506,">="&DATE(L27,1,1),$B$27:$B$506,"<="&DATE(L27,12,31))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 03-17-2022, 07:22 AM #3
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    52

    Re: Calculate total amount based on given year

    Thank you so much @Bo_RY.
    It works great.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Calculate total amount partially based on Yearly from other sheet.
    By Abdur_rahman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-11-2020, 10:03 AM
  2. Calculate amount of days per year within range
    By constructionbart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2014, 05:24 AM
  3. Trying to calculate a Daily Total Amount of Payments Due based on List of Subscribers
    By morphers in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2012, 01:43 PM
  4. Calculate amount based on circumference / divide total in 2 locations
    By JACKIECOTHRON in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2012, 02:55 PM
  5. How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM
  6. Calculate the total amount by date
    By 肥權 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2005, 12:45 PM
  7. [SOLVED] How do I calculate Amount of Sales Tax from Total Amount?
    By MikeS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2005, 04:06 PM

Tags for this Thread

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