Issue 26298 - COUNT.IF FUNCTION
Summary: COUNT.IF FUNCTION
Status: CLOSED FIXED
Alias: None
Product: documentation
Classification: Unclassified
Component: Manuals (show other issues)
Version: OOo 1.0.1
Hardware: All Linux, all
: P4 Trivial (vote)
Target Milestone: OOo 2.2
Assignee: issues@documentation
QA Contact: issues@documentation
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2004-03-10 12:26 UTC by suc
Modified: 2008-05-18 00:06 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description suc 2004-03-10 12:26:24 UTC 
En el manual-ayuda no se explica cómo  realizar filtrados multicriterio en la función COUNT.IF
Comment 1 flibby05 2004-03-10 17:33:05 UTC 
google translates as follows:

"In the manual-aid it is not explained how to make filtrates multicriterion in
function COUNT.IF"

reporter, can you please clarify in English language?
Comment 2 mjneedles 2004-04-09 04:56:32 UTC 
Translation:
In the help manual, it is not explained how to use multi-criteria filters in the
COUNTIF function.
Comment 3 thackert 2004-10-24 18:47:40 UTC 
I see that there is not any following entry since April. Could this issue be
closed or does it appear in newer versions of OOo?
Comment 4 flibby05 2004-10-30 15:47:32 UTC 
changing defect -> enhancement
Comment 5 drking 2006-11-23 06:09:35 UTC 
May I suggest that this issue is now closed?

There are several other ways to count and sum using multiple criteria - eg
DCOUNT, DSUM, SUMPRODUCT, SUM with array formulae - as well as simply putting in
an extra column.

I'm planning to contribute to the Help to clarify this.
Comment 6 Uwe Fischer 2006-11-24 13:06:16 UTC 
The help for COUNTIF and SUMIF got improved in CWS hcshared06, which will be
integrated into OOo 2.2
Comment 7 ace_dent 2008-05-17 22:03:00 UTC 
The Issue you raised has been marked as 'Resolved' and not updated within the
last 1 year+. I am therefore setting this issue to 'Verified' as the first step
towards Closing it. If you feel this is incorrect, please re-open the issue and
add any comments.

Many thanks,
Andrew
 
Cleaning-up and Closing old Issues
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html
Comment 8 ace_dent 2008-05-18 00:06:58 UTC 
As per previous posting: Verified -> Closed.
A Closed Issue is a Happy Issue (TM).

Regards,
Andrew