[libreoffice-users] SUM, SUMIF, IF, INDEX, MATCH, VLOOKUP?

Hi,

I am quickly losing patience with a task that requires a sum of values 
that occur on the same date, but at different times.

My raw data sheet is in 4 columns
Date/Time | Value 1| Value Y| Value z
2021-10-08 08:00:00| 5| 7| 0.15
2021-10-08 14:05:16| 3| 10| 5
2021-10-09 10:05:30| 15| 3| 25
2021-10-09 18:00:00| 15| 9| 6
...
..
.

I have a secondary sheet with just the date i.e. 2010-10-08, acquired 
with formula `=LEFT($Data.A4,10)'. Column B of this sheet needs to be 
the SUM of all the numbers in the 3rd column, BUT only for the date in 
column A i.e.

2010-10-08| 17
2010-10-09| 12
...
..
.

I have tried many Google searches and seen many videos on how this is 
supposed to work yet for some reason, being race, colour, creed, or 
stupidity, I cannot get the result I seek. It would seem that the 
summation of data with the same date, but different time component in 
the main data sheet is causing an issue.

I'd really appreciate some pointers here, even if not possible. If not 
possible what could be done. I just don't understand the 
INDEX(MATCH())/vlookup  argument.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy