Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Create 3D formula's|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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.