Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 16 Jan 2020 09:34:16 +0100How can I automate adding subtotals in the next columnhttps://ask.libreoffice.org/en/question/225265/how-can-i-automate-adding-subtotals-in-the-next-column/Hello,
I am trying to add subtotals in the next column. The data is a little large spanning across 10k rows. How can I automate?
Pankaj Pankaj2006Thu, 16 Jan 2020 09:34:16 +0100https://ask.libreoffice.org/en/question/225265/How to have several subtotals in the same sheet?https://ask.libreoffice.org/en/question/179108/how-to-have-several-subtotals-in-the-same-sheet/ Hello,
Assuming I have rows with people info and need to calculate two subtotals, an age average per sex and years of work, and a standard deviation per sex and years of work (this is just an example outlining grouping and sorting on two columns, not one as in the application dialog), how do I achieve it?
I can make one subtotal only, the second one seems to replace it, or I don't understand the methodology.
Thank you.msdobrescuSat, 12 Jan 2019 19:16:26 +0100https://ask.libreoffice.org/en/question/179108/how do I keep same number format in subtotals as that i am subtotallinghttps://ask.libreoffice.org/en/question/163675/how-do-i-keep-same-number-format-in-subtotals-as-that-i-am-subtotalling/ When I subtotal a money column, the result is givein in date format.phil77Thu, 23 Aug 2018 18:54:16 +0200https://ask.libreoffice.org/en/question/163675/how to hilight subtotals on calc version 5.4.5.1 machttps://ask.libreoffice.org/en/question/147544/how-to-hilight-subtotals-on-calc-version-5451-mac/ I have just instaled Version: 5.4.5.1 on my mac, and when i do a Subtotal operation on Calc, the subtotal rows does not appear bold as in previous versions.
What can be the problem? Can you help me?AntonioMon, 26 Feb 2018 13:12:03 +0100https://ask.libreoffice.org/en/question/147544/In Calc, how can I customize the captions added by Data->Subtotals, e.g. change "Result" to "Subtotal" and change "Grand Total" to "Total"?https://ask.libreoffice.org/en/question/136487/in-calc-how-can-i-customize-the-captions-added-by-data-subtotals-eg-change-result-to-subtotal-and-change-grand-total-to-total/ The subtotals feature calculates the subtotals of categories and adds a caption (in my case "Result") and the subtotal. Now I want to change the automatically generated caption "Result" to an arbitrary string.IdontlikeRegsMon, 30 Oct 2017 13:35:58 +0100https://ask.libreoffice.org/en/question/136487/Consecutive Cells from columnhttps://ask.libreoffice.org/en/question/94018/consecutive-cells-from-column/Hello, I am looking for an equation that will give me the total of consecutive cells...
![image description](/upfiles/1493757872279299.jpg)
Basically I am looking for the formula in the Count Column (G) to return the same manual entered totals in (F). Column (F) will be deleted if I can get the formula to work...
I currently have =SUBTOTAL(9,E2:E$10000)*2-SUM(E2:E$10000) but that is only returning "0". Any ideas? Thanks in advance!ForcedLibreUserTue, 02 May 2017 21:43:52 +0200https://ask.libreoffice.org/en/question/94018/libreOffice calc subtotal in macrohttps://ask.libreoffice.org/en/question/87860/libreoffice-calc-subtotal-in-macro/I am trying to move from excel I need a macro to subtotal but I can only get it to bring up the dialog. What arguments is dispatcher.executeDispatch(document, ".uno:DataSubTotals", ... looking for? rnorton22508Fri, 17 Feb 2017 03:08:42 +0100https://ask.libreoffice.org/en/question/87860/Subtotals returns TRUE in a subtotals cellhttps://ask.libreoffice.org/en/question/69694/subtotals-returns-true-in-a-subtotals-cell/I'm trying to count how many adults there are in a given cell range. This is a column where the information "adult" or "child" (as string) is calculated with an "if" formula based on the birth date entered in another column.
The Data -> Subtotals function gives me TRUE instead of the number of cells where "adult" is.
I tried with several different counts (count, counta, countif, ...) but always the same result. This question has been asked before, but the answer did not help me.
Thank you.AndyfcWed, 11 May 2016 11:23:40 +0200https://ask.libreoffice.org/en/question/69694/What's wrong with this formula?https://ask.libreoffice.org/en/question/61729/whats-wrong-with-this-formula/Hi,
I have a standard filter applied to one or more columns and need to count the resulting **visible** cells in another column that equal a certain value. In Excel this can be done with the following formula:-
=SUMPRODUCT(SUBTOTAL(3,OFFSET(BH10,ROW(BH10:BH1000)-ROW(BH10),0))*(BH10:BH1000="T"))
This counts the number of visible cells in column BH that equal "T". The result happens to be 29, however when I use this same formula in Calc on the same spreadsheet I get 270538 !. Anyone know what could be going on here?. Thanks. p.s. I should add that it makes no difference if the formula is entered as an array formula or not.
LO 4.4.6.3 on Linux.redartTue, 08 Dec 2015 17:47:10 +0100https://ask.libreoffice.org/en/question/61729/Count filtered rows with additional criteriahttps://ask.libreoffice.org/en/question/61520/count-filtered-rows-with-additional-criteria/Hi,
Looking for a formula to count the number of rows in a filtered list that also satisfy an additional, unfiltered, criteria.
In Excel I can do this by combining the SUMPRODUCT and SUBTOTAL functions, as per the following .....
=SUMPRODUCT((LEFT(BH2956:BH3964)="T")*SUBTOTAL(3,OFFSET($A2956:$A3964,ROW(C1:INDEX($C:$C,ROWS($C2956:$C3964)))-1,,1)))
This doesn't work in Calc. Instead of the correct answer 53, it gives 411866. TBH I don't understand how the Excel formula works - it was offered as a solution on one of the Excel forums. Hoping there's perhaps a better way to accomplish this in Calc. Thanks.
redartWed, 02 Dec 2015 16:08:15 +0100https://ask.libreoffice.org/en/question/61520/How to add subtotals in Pivot Table?https://ask.libreoffice.org/en/question/45654/how-to-add-subtotals-in-pivot-table/Hi,<br>
in LibreOffice 4.3.5.2 Calc is there a way to add subtotals to Pivot Table?
See below sample.<br>
Thanks<br>
![image description](/upfiles/14228826077135677.png)L-userMon, 02 Feb 2015 14:11:45 +0100https://ask.libreoffice.org/en/question/45654/Subtotal function acts weirdhttps://ask.libreoffice.org/en/question/6799/subtotal-function-acts-weird/Hi all,
I have two columns : first one for incomes et second for people. I activated the auto-filter thus I can display all incomes for a particular person. (see attached [C:\fakepath\subtotal-example.ods](/upfiles/13500783483576266.ods)).
My question : I tried to use the subtotal function to track the total amount of incomes for each person...but as soon as my display filter parameters change, the subtotal change :o(
Do I use the subtotal function the wrong way or simply misunderstood it ? and above all, how would you achieve this goal (total based on display filter results)
Thank you !sulliwaneFri, 12 Oct 2012 23:44:25 +0200https://ask.libreoffice.org/en/question/6799/Does SUBTOTAL have Functions which ignore hidden data?https://ask.libreoffice.org/en/question/29554/does-subtotal-have-functions-which-ignore-hidden-data/MS Excel has a series of SUBTOTAL Functions which ignore hidden data. These Functions are numbered similarly to the base Functions, but starting at 100. For example,
Use all data and get the AVERAGE: 1
Ignore hidden data and get the AVERAGE: 101
It does not appear that LibreOffice support these 100 series Functions.
Is that correct?
Is there another way to get the same behavior?
Is this a feature planned for future implementation?co_buckfastFri, 07 Feb 2014 22:58:41 +0100https://ask.libreoffice.org/en/question/29554/How do you get subtotal labels on the 2nd and 3rd subtotals?https://ask.libreoffice.org/en/question/20513/how-do-you-get-subtotal-labels-on-the-2nd-and-3rd-subtotals/Am a new user trying to make subtotals readable. My logic is:
subtotal 1 - using column Agt Type, count the rows add total to Agt Type column
subtotal 2 - using column Agt Type, sum the totals of Fares and add it to the fares column
subtotal 3 - using column Type, count the rows and add total to Type.
Attached are the Excel expample and what I have figured out for Libre. Why aren't there labels for the subtotals for group 2 and 3? Looking at this report, no one would know what was being subtotaled.
Am having issues with adding these files. If they are not attached please let me know.
Thanks,
ConnieCPNewUserFri, 19 Jul 2013 23:30:52 +0200https://ask.libreoffice.org/en/question/20513/