Issue 110421 - Create 3D formula's
Summary: Create 3D formula's
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-03-26 18:06 UTC by taskbar
Modified: 2013-01-29 21:49 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 taskbar 2010-03-26 18:06:41 UTC 
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.
Comment 1 Regina Henschel 2010-03-26 18:28:26 UTC 
3D ranges should be possible in COUNTIF and in SUMIF as they are in COUNT and SUM.

=SUM(Sheet1.A3:Sheet3.A3)
=COUNT(Sheet1.A3:Sheet3.A3)
work, but
=SUMIF(Sheet1.A3:Sheet3.A3;">0")
=COUNTIF(Sheet1.A3:Sheet3.A3;">0")
fail.