Re: [libreoffice-users] COUNTIFS with cells of yyyy-mm-dd

thank you all for your replies ...

using your suggestions  following will
do what I wanted to accomplish:


=COUNTIFS(A10:A500,">="&DATE(2016,1,1),A10:A500,"<="&DATE(2016,12,31),F10:F500,"="&"ZZZ")

and I have another cell with the above using
'SUMIFS' instead , therfeore, working  on data in three columns ...



thanks,
F-





On Wed, 5 Oct 2016, FHDATA wrote:

> hello,
>
>
> I have yyyy-mm-dd as my date format in Calc (libreoffice 5.1.5.2) .
>
> I like to count number of cells for a
> certian year *only* ....
>
> sample data :
>
> 2011-03-28
> 2013-08-19
> 2014-07-02
> 2015-01-11
> 2016-05-30
>
>
> for any year, let say 2011,  gives me err510
> =COUNTIF(A1:A50,DATE(2011,*))
>
>
> any help is appreciated.
>
> F-
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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