Forum Discussion

fdefever's avatar
fdefever
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's avatar
    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.

     

     

fdefever's avatar
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's avatar
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.

Resources