Reply without the other stuff since this is somewhat long.
Wanted to try to create a macrothat would do everthing
with just the original data in columns A-D.
With old Quattro pro would have been amuch simpiler
process.. Would be nice if we could upload sheets.
Well, just wanted to see if I
=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
On 15 Dec 2021 at 21:11, Hylton Conacher (ZR1HPC)
wrote:
Date sent: Wed, 15 Dec 2021 21:11:55 +0200
To: LibreOffice Users
From: "Hylton Conacher (ZR1HPC)"
Subject:[libreoffice-users] SUM, SUMIF, IF, INDEX,
MATCH, VLOOKUP?
>
On 2021-12-15 14:11, Hylton Conacher (ZR1HPC) wrote:
...
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 [spaced for comprehension]
Date/Time [stamp] | Value 1| Value Y| Value z
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