Apache OpenOffice (AOO) Bugzilla – Issue 51072
COUNTIF should allow wildcards
Last modified: 2005-06-30 12:14:52 UTC
Excel's version of COUNTIF supports wildcards * and ? in the criteria, but Calc doesn't. These wildcards have been in use since CP/M (before Microsoft!) and I can't see any reason for Open Office not to use them. I use the criteria "??*" to count both "Op" and "Ins" because my instructors are also operators and I want a total of everyone who can operate. I just want to count all the 2 and 3 letter words. I don't want to use regular expressions.
This is a double to Issue 32344 . *** This issue has been marked as a duplicate of 32344 ***
closed double