Formulas not working on new laptop!

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3145454%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EFormulas%20not%20working%20on%20new%20laptop!%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3145454%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20purchased%20a%20new%20laptop%20and%20formulas%20that%20work%20in%20Excel%20on%20my%20old%20laptop%20are%20not%20showing%20up.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThey%20are%20basic%20IF%20statements%20to%20tally%20up%20figures%20and%20sums%20that%20all%20show%20zero%20on%20my%20new%20computer.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346857iC1C37281B50D4D3A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22pdubz_0-1644438345371.png%22%20alt%3D%22%5C%26quot%3Bpdubz_0-1644438345371.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EBelow%20I%20have%20copied%20what%20the%20formulas%20look%20like%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346858iCD86B6C3FAC6EAC8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22pdubz_1-1644438399079.png%22%20alt%3D%22%5C%26quot%3Bpdubz_1-1644438399079.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIm%20guessing%20it%20is%20a%20setting%20I%20havent%20clicked%20on%20or%20off%20-%20driving%20me%20mad%20and%20hopefully%20someone%20can%20help!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPete%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3145454%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Hi

 

I purchased a new laptop and formulas that work in Excel on my old laptop are not showing up.

 

They are basic IF statements to tally up figures and sums that all show zero on my new computer.

 

pdubz_0-1644438345371.png

 

Below I have copied what the formulas look like

 

pdubz_1-1644438399079.png

 

Im guessing it is a setting I havent clicked on or off - driving me mad and hopefully someone can help!

 

Pete

5 Replies

@pdubz 

1) Make sure that the Show Formulas button in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.

2) Make sure that the number format is not set to Text.

@Hans Vogelaar 

 

Thanks. Just to make clear this is the exact same file I opened up on my old laptop file (taken off the cloud).

 

1) I always have that turned off. I turned it on to show the working out for this example

2) Its set to numbers - its the same file as what works on my other laptop

 

 

@pdubz 

Can you provide some information about the formulas that don't work?

@Hans Vogelaar They are just if statements, tallying up rows of numbers entered across a series of months

 

=IF($J$2="ALL",SUM(B$21:B$238),SUMIF($F$21:$F$238,"<="&DATEDIF($J$2,$I$2, "m"),B$21:B$238))

 

 

@pdubz 

Weird. Does the new laptop have a different language setting than the previous one?