Getting firstsortedvalue from spreadsheet with multiple entries per date
I hope someone will be able to help me, I have been struggeling and googling for a couple of weeks on and off. And I am quite sure it should be possible to fix my issue - I just don't know how.
I have a spreadsheet of multiple dates and data entries - see attached image. Each date has several entires. I need to be able to display the latest date in the spreadsheet along with the summed value of each column (for instance ZBB 3 column what I need to display in a text box is "19-12-2018 00:00:00 ZBB 3 = 1" )
I have tried practically all combinations of aggr and sum (except for the right one) 🙂