To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=41853
                  Issue #:|41853
                  Summary:|Help text for function SUMIF lacks details
                Component:|Spreadsheet
                  Version:|OOo 1.1
                 Platform:|PC
                      URL:|
               OS/Version:|All
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|ENHANCEMENT
                 Priority:|P3
             Subcomponent:|ui
              Assigned to:|spreadsheet
              Reported by:|ms2





------- Additional comments from [EMAIL PROTECTED] Tue Feb  1 16:05:54 -0800 
2005 -------
In the help text to the functions SUMIF there is no example of embedding the
criteria in the formula directly. This should get added.

e.g. as a second exmple

        To sum up only negative numbers, this will do:
        SUMIF(A1:A10;"<0")

or one hint in the description like this:

        If the criteria is written into the formula, it has to be surrounded by
        double quotes.


I tell you why:
I'm using calc only for simple things like summing up rows and having
data in columns and rows. One day I wanted to sum up only the negative
numbers of a column and with my small background in using calc formulas
i was stuck. Because I did not know and was not told that if the criteria
is written into the formula directly, it has to be wrapped in double quotes.

I don't know for sure, but I can imagine that some more help texts are
lacking examples showing all possible cases...

All this relates to the english version of OOo1.1.0.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to