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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks