And, for 2 criteria like this: =SUMPRODUCT((YEAR(A1:A50)=2011)*(B1:B50="ZZZ"))
On Sat, Oct 8, 2016 at 9:38 PM, m.a.riosv <[email protected]> wrote: > Or > > =SUMPRODUCT(YEAR(A1:A50)=2011) > > Miguel Ángel. > > > > -- > View this message in context: http://nabble.documentfoundation.org/ > COUNTIFS-with-cells-of-yyyy-mm-dd-tp4195901p4196282.html > Sent from the Users mailing list archive at Nabble.com. > > -- > To unsubscribe e-mail to: [email protected] > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
