Calculate accumulated values for each day during the last 90 days from newest date

[sealpino]

In a basic file I have a long list of values connected to different dates.
I would like to see the values for same dates accumulated.
The list can be more than 365 days of values.
I want to see the last 90 days of newest day in my presentation!

[AliGW]

I don't understand your expected results. 90 days back from the latest date in your list includes ALL of the sample dates, not just the ones you have listed.

This filters to the latest 90 days:

=FILTER(B3:C19,B3:B19>=MAX(B3:B19)-90)

[AliGW]

Sorry - just realised that it is in fact this that you need:

=LET(f,FILTER(B3:B19,B3:B19>=MAX(B3:B19)-90),u,UNIQUE(f),s,SUMIF(B3:B19,u,C3:C19),HSTACK(u,s))

=LET(f;FILTER(B3:B19;B3:B19>=MAX(B3:B19)-90);u;UNIK(f);s;SUMMA.OM(B3:B19;u;C3:C19);HSTACK(u;s))

[sealpino]

You are so right! with your great skill.
That is spot on.
Thank you so much!

[HansDouwe]

To realize the requirements mentioned in your sheet, add the blue parts to the formula of Ali.

=LET(f,FILTER(B3:B19,(B3:B19>=MAX(B3:B19)-90)*(D3:D19="")),u,UNIQUE(f),s,SUMIFS(C3:C19,B3:B19,u,D3:D19,"="&""),SORT(HSTACK(u,s),,-1))

[AliGW]

Thanks for the rep.

[sealpino]

I got confused how I could put these figure in dated order!
Oldest date as the figure in the bottom, as last figure in the column.
I could not use filter to ask for lowest or highest figure!
How can it be adjusted?

Opps I found it! ALl OK no need of comments

[HansDouwe]

Please try

=LET(f,FILTER(B3:B19,B3:B19>=MAX(B3:B19)-90),u,UNIQUE(f),s,SUMIF(B3:B19,u,C3:C19),SORT(HSTACK(u,s),,-1))