Issue 110421

Summary:	Create 3D formula's
Product:	Calc	Reporter:	taskbar <b.jurg>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, rb.henschel
Version:	OOo 3.2	Keywords:	oooqa
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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.