Forum Discussion
Excel Summing Formulas in Microsoft 365 Not Working Properly
Hello.
Since I signed up for the Family version of Microsoft 365, I have to manually re-enter my summing formulas each time I open the spreadsheet. Here is an example of the sum formula I'm using and shows how it didn't calculate:
I'm using a PC laptop and the desktop version of Microsoft Excel 365.
Looking forward to seeing some suggestions. It's not a hard thing to have to do each time; it's just a pain in the butt.
Thank you.
Bkwerm88
First, you are summing a single value. G5-H5 is enough.
Second, automatic calculation is probably switched off.
First, you are summing a single value. G5-H5 is enough.
Second, automatic calculation is probably switched off.
- Sweet! Turning the automatic calculation on did the trick. Thanks so much.
