SOLVED

Subtotal function not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1308439%22%20slang%3D%22en-US%22%3ESubtotal%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308439%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Excel%20(from%20office.com)%2C%26nbsp%3B%3CSPAN%3EI've%20tried%20the%20SUBTOTAL()%20function%2C%20but%20it%20doesn't%20work%2C%20only%20the%20text%20of%20the%20function%20is%20displayed%20in%20the%20cell%2C%20not%20the%20subtotal%20value.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E1st%20thing%2C%20even%20so%20all%20my%20Windows%20interfaces%20are%20in%20English%2C%20the%20Excel%20formulas%26nbsp%3Bshow%20up%20in%20German%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESo%20this%20%3DSUBTOTAL(9%2CF8%3AF40)%20turns%20into%20this%3A%26nbsp%3B%3D%3CSTRONG%3ETEILERGEBNIS(9%2CF8%3AF40)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EF9%20fn%20key%20doesn't%20do%20anything%20here.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20465px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F184446i619DE7DF7BBC1888%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20idea%3F%20thanks.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1308439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308490%22%20slang%3D%22en-US%22%3ERe%3A%20Subtotal%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622146%22%20target%3D%22_blank%22%3E%40fdefever%3C%2FA%3E%26nbsp%3BThe%20format%20of%20the%20cell%20may%20be%20%22Text%22.%20Set%20it%20to%20%22General%22%2C%20click%20in%20the%20cell%20and%20press%20Enter.%20That%20should%20fix%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%2C%20since%20your%20Excel%20version%20is%20German%2C%20you%20may%20have%20to%20enter%20a%20semi-colon%20in%20stead%20of%20a%20comma%20to%20separate%20the%20arguments%20in%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308533%22%20slang%3D%22en-US%22%3ERe%3A%20Subtotal%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks%20for%20pointing%20out%20using%20'%3B'%20that%20fixed%20the%20formula!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20wonder%20how%20to%20switch%20the%20formulas%20to%20English%3F%3C%2FP%3E%3CP%3Ethanks%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308594%22%20slang%3D%22en-US%22%3ERe%3A%20Subtotal%20function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308594%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622146%22%20target%3D%22_blank%22%3E%40fdefever%3C%2FA%3E%26nbsp%3BHaven't%20tried%20myself%2C%20but%20believe%20you%20can%20download%20other%20language%20packs.%20under%20FILE%2C%20Options%2C%20Language.%20Didn't%20click%20all%20the%20way%20through%20but%20it%20seems%20you%20can%20choose%20from%20many%20languages%20and%20it%20requires%20a%20restart.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-04-15%20at%2010.52.00.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F184461i6732AE46606C6E9C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-04-15%20at%2010.52.00.png%22%20alt%3D%22Screenshot%202020-04-15%20at%2010.52.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 my Windows interfaces are in English, the Excel formulas show up in German?

 

So this =SUBTOTAL(9,F8:F40) turns into this: =TEILERGEBNIS(9,F8:F40)

F9 fn key doesn't do anything here.

 

image.png

 

Any idea? thanks.

3 Replies
Best Response confirmed by fdefever (New Contributor)
Solution

@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.

 

 

Highlighted

@Riny_van_Eekelen Thanks for pointing out using ';' that fixed the formula!

 

Now I wonder how to switch the formulas to English?

thanks again.

Highlighted

@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.

Screenshot 2020-04-15 at 10.52.00.png