source/text/scalc/01/04060106.xhp | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
New commits:
commit 3836c655e7d419cd3d401e51e4572996b4308a85
Author: Pierre F <f...@bger.ch>
AuthorDate: Wed Jul 10 16:32:03 2024 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jul 11 16:14:07 2024 +0200
clarify SUBTOTAL example. from
https://ask.libreoffice.org/t/autofiltre-sous-total-nb-si/107742/7
Change-Id: I8947feee1c862751124d372ac84f68ab838e34f1
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/170294
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 3cd61a4c23..1c80c7a546 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -1196,7 +1196,7 @@
<embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph id="par_id3143638" role="paragraph">You have a table in the cell
range A1:B6 containing a bill of material for 10 students. Row 2 (Pen) is
manually hidden. You want to see the sum of the figures that are displayed;
that is, just the subtotal for the filtered rows. In this case the correct
formula would be:</paragraph>
+<paragraph id="par_id3143638" role="paragraph">You have a table in the cell
range A1:B6 containing a bill of material for 10 students.</paragraph>
<table id="tbl_200820170737188127">
<tablerow>
@@ -1278,6 +1278,8 @@
</tablerow>
</table>
+<paragraph id="par_id3140008" role="paragraph">Let's say one row is manually
hidden, then the first formula shows the sum of the 5 figures filtered; the
second, only the sum of the 4 figures displayed.</paragraph>
+
<paragraph id="par_id3143658" role="paragraph"><item
type="input">=SUBTOTAL(9;B2:B6) returns 50.</item></paragraph>
<paragraph id="par_id200820170751218092" role="paragraph"><item
type="input">=SUBTOTAL(109;B2:B6) returns 40.</item></paragraph>
</section>
