Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

=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
Copy down Column F
G2 - Same as F
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) 

Date sent:Wed, 15 Dec 2021 21:11:55 +0200
From:0;Hylton Conacher (ZR1HPC)
Subject:=[libreoffice-users] SUM, SUMIF, IF, INDEX, 


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

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.