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

=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 Usersusers@global.libreoffice.org
From:0;Hylton Conacher (ZR1HPC)hylton@conacher.co.za
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: 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




-- 
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