To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110421
                 Issue #|110421
                 Summary|Create 3D formula's
               Component|Spreadsheet
                 Version|OOo 3.2
                Platform|All
                     URL|
              OS/Version|All
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|FEATURE
                Priority|P3
            Subcomponent|ui
             Assigned to|spreadsheet
             Reported by|taskbar





------- Additional comments from [email protected] Fri Mar 26 17:06:41 
+0000 2010 -------
I often need to count items across multiple sheets. Within Excel I created my
own formula for it which looks kinda like this:

  countifsheets("sheet";A3;"x")

which counts all the "x" at cell A3 on sheets starting with "sheet".

Besides a count across sheets, I can imagine a sum would also be useful.

These kind of formula's are typically useful where you have forms where
statistics should be done upon.

---------------------------------------------------------------------
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