=The subtotal seems to cause issues, so another option. Again in Column E: E1: Date Only E2:Ex: =int(a2) copy down F2 - Formula $5 needs to be changed to last row =IF(E2E3,SUMIFS($C$2:$C$5,$E$2:$E$5,=uot;INT($A$2:$A$5)),) Copy down Column F G2 - Same as F =IF(E2E3,E2,) Copy down Column G
Data is there, but blank cells. Can use Ctrl-Shift-V to copy to other location and then do a data sort ascending to get ridof blank lines. On 15 Dec 2021 at 21:11, Hylton Conacher (ZR1HPC) wrote: Date sent:Wed, 15 Dec 2021 21:11:55 +0200 To:=LibreOffice [email protected] From:0;Hylton Conacher (ZR1HPC)[email protected] Subject:=[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</span> 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())/vlookupargument. -- To unsubscribe e-mail to: [email protected] 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 -- To unsubscribe e-mail to: [email protected] 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
