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

------------------------------

=IF(LEFT(A2,10)=("2021-10-08"),B2,"")

------------------------------

If you paste that formula into column E, you should have nulls where the
date does not match and the value in Column B where the date matches.
========================
Note the above suggestion requires column A left in TEXT format. If you
import your data as or convert it to a DATE VALUE, then "-" (equals) won't
work if you have hours/minutes/seconds included in column A (since the date
has no fractional value but unless you record something at midnight the
values in column A will all have fractional values (the HHMMSS represented
as a fractional portion of a day.) If you're dealing with DATE VALUEs You'd
need to do both a < and >= embedded in parenthesis to capture all values
within the day:

---------------------------------
IF (A2<10/8/21,IF(A2>=10/9/21,B2,""),"")
---------------------------------

I validated the first example works... I haven't validated the 2nd, but the
methodology is sound, as long as my spelling and first attempt at the
specific logic are accurate.

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