Issue 110421

Summary: Create 3D formula's
Product: Calc Reporter: taskbar <b.jurg>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rb.henschel
Version: OOo 3.2Keywords: 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:


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.

work, but