Subtotals returns 0

English
#1

when the formula is =SUBTOTAL(9,$E$120:$E$120) I get 0 for the subtotal. I found if I delete all the $ in the formula the correct amount displays.

Any idea of what I am doing wrong?

Even with the range over multiple cells, it returns 0 for the value.

I looked at previous years workbooks and found what is missing in the formula; the page name. Nope, I am wrong.

example: =SUBTOTAL(9,Jan.$E$141:$E$160) Now to figure out why the subtotals function is not picking up the page name. The page names are the months of the year. I found several workbooks (diff years) do not have the page name. Nope, this is wrong

Tried to retag to calc… ok, thanks got that changed

Not a fix but, I found that if I go the task? bar and hit the = sign to the left then hit enter, the correct number displays. Problem resolved. autocalculate box was not checked as suggested. Thank you all for the help!

#2

I cannot confirm the strange behavior reported.

But. What do you expect of the SUBTOTAL() function applied to a single cell?

#3

This is not a question common to Writer, Calc, Impress, Draw, Base and Math. It is clearly a Calc one. Please retag to replace common by calc.

#4

The usual reason for what a sum may return an unexpected 0 is that the supposed numbers in the referred cells are text (looking like numbers).
However, this doesn’t depend on whether the addressing is relative o absolute.
Anyway: Don’t apply an explicit horizontal alignment to your cells (columns), and the mentioned difference will be obvious: Texts are displayed left aligned then, but numbers right aligned. Dont sacrifice this advantage to unneeded formatting.

#5

@ATR, To retag, choose retag (below your question), delete common, type calc and press Enter twice. Thanks.

#6

@ATR, AutoCalculate is checked? See menu Data - Calculate.

#7

Hello,

i thought i’ll just add this:

https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUBTOTAL

Take a look at the Examples section.

Hope that helps. (Even if it is a bit late).

#8

Choose menu Data - Calculate and check AutoCalculate.

See also LibreOffice Help on Recalculate.

Add Answer is reserved for solutions.

Check the mark (Correct answer mark) to the left of the answer that solves your question.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.