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

Hi,

Le 15/12/2021 à 20:11, Hylton Conacher (ZR1HPC) a écrit :
> 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'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.

A date-time is a floating number. The integer part being the date (from 
a reference day -- 12/30/1899 is a standard), the decimal part being the 
time (0.0 for OO:OO to 0.9999999... for 23:59:59...)
Thus it's no suprise that SUMIF and its siblings won't find a date.

-> Did you try querying on the INT() value of the date-time, which is 
the date part?

Best,
--
Jean-Francois Nifenecker, Bordeaux


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