Issue 51072 - COUNTIF should allow wildcards
Summary: COUNTIF should allow wildcards
Status: CLOSED DUPLICATE of issue 32344
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2005-06-21 21:20 UTC by navvy
Modified: 2005-06-30 12:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description navvy 2005-06-21 21:20:24 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 
Comment 1 frank 2005-06-30 12:14:31 UTC
This is a double to Issue 32344 .

*** This issue has been marked as a duplicate of 32344 ***
Comment 2 frank 2005-06-30 12:14:52 UTC
closed double