I have a range of cells containing movie titles followed by a year in parenthesis. How do I count the number of cells containing a particular year? In excel, the function =COUNTIF(A1:Z300,"(2014)") worked fine but now it’s returning 0. Any help would be much appreciated.
Also doesn’t work in Excel, the search string has to match the entire cell, so does not if there is other text before “(2014)”.
In Calc you can use regular expressions though, which would be ".*\(2014\)", but be aware that Excel does not support regular expressions if you want to interoperate the document with Excel.
Upcoming 5.2 will support also the simple wildcards known from Excel, which then would be "*(2014)"