Sum of each last day-time value

[JmPark]

Hello everyone, 

I want to, "only sum the last value of each day-time data".

For example, if my data looks like below 

I want to add the value of last date-time data(higlited the data what I want to add as bold style)

In this case so the Stock value will be (60+80+50), and Out will be(35+13+30)

And show the value in KPI in the sheet.

It would be greatful to know how to do this.

date/time	Stock	Out
2022.03.12 08:00:00	30	20
2022.03.12 10:00:00	50	30
2022.03.12 15:00:00	60	35
2022.03.13 9:00:00	40	10
2022.03.13 12:00:00	80	13
2022.03.14 11:00:00	25	13
2022.03.14 18:00:00	50	30

Thanks in advance.

[JacoAucamp]

Why don't you try (for Stock): sum(if(aggr(nodistinct max(Time(date/time)),Date(date/time)) = Time(date/time),Stock))

Why don't you try (for Out): sum(if(aggr(nodistinct max(Time(date/time)),Date(date/time)) = Time(date/time),Out))

Hope this helps