Dear Team,

Need your help to do YTD sum based on selection of month in financial year (April to March) i.e. if selected June month, sum should be from April to June, if selected October month, sum should be from April to October, if selected February month, sum should be from April to Feb.

Demo file is attached for your reference.

Thanks in advance

Attached Files

YTD Sum 050324.xlsx (11.4 KB, 4 views)

Hi and welcome. One of many ways attached

Attached Files

YTD Sum 050324.xlsx (11.5 KB, 5 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks a lot Pecoflyer. Literally I was struggling to get the result and you made my life easy.

You're welcome. Would have appreciated some rep, though...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post