SOLVED

Excel Summing Formulas in Microsoft 365 Not Working Properly

Copper Contributor

 

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:

 

Microsoft Excel Sum Error.jpg

 

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

2 Replies
best response confirmed by Bkwerm88 (Copper Contributor)
Solution

@Bkwerm88 

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.
1 best response

Accepted Solutions
best response confirmed by Bkwerm88 (Copper Contributor)
Solution

@Bkwerm88 

First, you are summing a single value. G5-H5 is enough.

Second, automatic calculation is probably switched off.

 

View solution in original post