Help with Quarter to date

[Eastii]

Hello Reader's,

Our financial year runs from Jan-19 to Dec-19. Currently we are in May-19 period therefore we have finalized actual sales data for the period Jan-19 to Apr-19 period.
I need help to construct a Quarter to date formula.

For example in below data: I need a formula that will calculate Q1 total as $370 in column "M" , Q2 total as $100 in column "N" (Quarter to date) which is just Apr-19 sales because May-19 and Jun-19 sales still not finalized.

While Q3 total must be $0.00 in column "O" and Q4 total must be $0.00 in column "P"

[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl71, width: 64"] [/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl69, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl69"]Actuals[/TD]
[TD="class: xl69"]Actuals[/TD]
[TD="class: xl69"]Actuals[/TD]
[TD="class: xl71"]Actuals[/TD]
[TD="class: xl69"]Actuals[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"]Forecast[/TD]
[TD="class: xl69"][/TD]
[/TR]
[TR]
[TD="class: xl70"]Jan-19[/TD]
[TD="class: xl70"]Feb-19[/TD]
[TD="class: xl70"]Mar-19[/TD]
[TD="class: xl72"]Apr-19[/TD]
[TD="class: xl70"]May-19[/TD]
[TD="class: xl70"]Jun-19[/TD]
[TD="class: xl70"]Jul-19[/TD]
[TD="class: xl70"]Aug-19[/TD]
[TD="class: xl70"]Sep-19[/TD]
[TD="class: xl70"]Oct-19[/TD]
[TD="class: xl70"]Nov-19[/TD]
[TD="class: xl70"]Dec-19[/TD]
[TD="class: xl69"][/TD]
[/TR]
[TR]
[TD="class: xl69"]100[/TD]
[TD="class: xl69"]150[/TD]
[TD="class: xl69"]120[/TD]
[TD="class: xl71"]100[/TD]
[TD="class: xl69"]130[/TD]
[TD="class: xl69"]100[/TD]
[TD="class: xl69"]200[/TD]
[TD="class: xl69"]300[/TD]
[TD="class: xl69"]600[/TD]
[TD="class: xl69"]300[/TD]
[TD="class: xl69"]700[/TD]
[TD="class: xl69"]100[/TD]
[TD="class: xl69"][/TD]
[/TR]
[TR]
[TD="class: xl69"]

[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[/TR]
[TR]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[/TR]
</tbody>[/TABLE]
I am hoping I have explained my self clearly, let me know otherwise.

Thank you for reading and answering my query, your time and support much appreciated. Regards Eastii.

 

[Eastii]

Sorry in the above table the May-19 should read as Forecast and not Actual