https://bugs.documentfoundation.org/show_bug.cgi?id=145407
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |NOTABUG
--- Comment #8 from Eike Rathke <er...@redhat.com> ---
First, the expression
=SUM( AND( MONTH(C32)=MONTH(C5:C13));DAY(C32)=DAY(C5:C13) )
probably was intended as
=SUM( AND( MONTH(C32)=MONTH(C5:C13);DAY(C32)=DAY(C5:C13)) )
instead (note that in the former AND() receives one argument and in the latter
two arguments).
Second, there seems to be a misconception of AND(), it never returns an
array/matrix (neither does OR()), but computes a logical AND of all arguments,
including their matrix elements. That has always been the case and will not
change. See also
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#AND
Use SUM() as in comment 4 or
=SUMPRODUCT(MONTH(C32)=MONTH(C5:C13);DAY(C32)=DAY(C5:C13))
as regular formula.
--
You are receiving this mail because:
You are the assignee for the bug.
