+ Reply to Thread
Results 1 to 2 of 2

Sum by YTD(year to Date) as financial year from 1st April to 31st march

  1. #1
    Registered User
    Join Date
    02-28-2022
    Location
    mumbai
    MS-Off Ver
    ms officeb2010
    Posts
    16

    Sum by YTD(year to Date) as financial year from 1st April to 31st march

    Sum by YTD(year to Date) as financial year from 1st April to 31st march so that YTD quantity grand total from sheet abc data pull into formate sheet
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,366

    Re: Sum by YTD(year to Date) as financial year from 1st April to 31st march

    Please try

    =SUMIFS(abc!$C:$C,abc!$A:$A,">=" &DATE(YEAR($C$1),4,1),abc!$A:$A,"<=" & $C$1)

    =SUMIFS(abc!$B:$B,abc!$A:$A,">=" &DATE(YEAR($C$1),4,1),abc!$A:$A,"<=" & $C$1)

    OR

    =SUMIFS(abc!$B:$B,abc!$A:$A,">="&DATE(YEAR($C$1),4,1),abc!$A:$A,"<="&DATE(YEAR($C$1)+1,3,31))
    Last edited by JohnTopley; 06-17-2022 at 10:40 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Charting financial year (April to March)
    By Smudge.Smith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-22-2020, 06:40 AM
  2. [SOLVED] Australian Financial Year from Month and year
    By tomca in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2019, 03:32 AM
  3. [SOLVED] Extracting Fiscal Year / Financial Year based on the Quarters using the
    By Asad Mir in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2019, 08:55 AM
  4. Replies: 3
    Last Post: 01-24-2019, 11:00 AM
  5. [SOLVED] How to get month and year of previous and current financial year?
    By mso3 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 04-11-2017, 05:19 AM
  6. [SOLVED] Get a financial year from April by formula
    By mso3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2015, 10:12 AM
  7. Change date to end of month if unless 5th April year end
    By aaaaaaiden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2014, 07:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1