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+unsubscr...@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