Feb 09 2022 12:27 PM
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.
Below I have copied what the formulas look like
Im guessing it is a setting I havent clicked on or off - driving me mad and hopefully someone can help!
Pete
Feb 09 2022 12:48 PM
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.
Feb 09 2022 12:58 PM
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
Feb 09 2022 01:12 PM
Can you provide some information about the formulas that don't work?
Feb 09 2022 01:21 PM
@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))
Feb 09 2022 02:07 PM
Weird. Does the new laptop have a different language setting than the previous one?