Forum Discussion

Copper Contributor

Apr 15, 2020

Solved

Subtotal function not working

I'm using Excel (from office.com), I've tried the SUBTOTAL() function, but it doesn't work, only the text of the function is displayed in the cell, not the subtotal value. 1st thing, even so all ...

excel

Formulas and Functions

Riny_van_Eekelen
Apr 15, 2020
fdefever The format of the cell may be "Text". Set it to "General", click in the cell and press Enter. That should fix it.

Or, since your Excel version is German, you may have to enter a semi-colon in stead of a comma to separate the arguments in the formula.

Riny_van_Eekelen

Platinum Contributor

Apr 15, 2020

fdefever The format of the cell may be "Text". Set it to "General", click in the cell and press Enter. That should fix it.

Or, since your Excel version is German, you may have to enter a semi-colon in stead of a comma to separate the arguments in the formula.

fdefever
Copper Contributor
Apr 15, 2020
Riny_van_Eekelen Thanks for pointing out using ';' that fixed the formula!

Now I wonder how to switch the formulas to English?
thanks again.
- Riny_van_Eekelen
  Platinum Contributor
  Apr 15, 2020
  fdefever Haven't tried myself, but believe you can download other language packs. under FILE, Options, Language. Didn't click all the way through but it seems you can choose from many languages and it requires a restart.