How To Sum & Average Based On Elapsed Date?

[xlmaniac]

Dear All,
I do have the below data set made for a month.
I want to calculate the Month-Tilll-Date(Cumulative) Value/average based on the Elapsed date.
For the 1st KPI(GRN), the value should get added for Target & Ach(under Column B & C) once today's date is greater than the previous date/s.
Similarly for he 2nd KPI, the average of Target & ach(under Column B & C) should get populated once today's date is greater than the previous date/s.
Pls help with the formulae under Column B & C which can yield this result.

 

[jasonb75]

Try this in B3, then fill right to D3

=SUMIFS(E$3:AO$3,$E$1:$AO$1,"<"&TODAY())

and this in B4, then drag right to D4

=AVERAGEIFS(E$3:AO$3,$E$1:$AO$1,"<"&TODAY())

 

[xlmaniac]

Thanks a lot Jasonb75 for the excellent solution!!
Really appreciate your support.
Regards
Xlmaniac