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+unsubscr...@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+unsubscr...@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