excel for mac 15.36 not returning sum of cells

#Excel for mac 15.36 not returning sum of cells update#
#Excel for mac 15.36 not returning sum of cells manual#
#Excel for mac 15.36 not returning sum of cells full#

To see the effects of opening Excel workbooks with different calculation option settings, watch this short Excel tutorial video. In most cases though, the problem is the Automatic Calculation setting. My named range was on a different sheet, so the location was the problem. Thanks to Stuart Valentine, who posted a link to a discussion of this SUMIFS problem. There is problem with SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS, in Excel 2010, when the references are on a different sheet. Of course, this solution could stop working again, at the next lunar eclipse! Why that worked, I have no idea, but if you run into a similar problem, maybe it will help you too. Miraculously, that solved the problem! I held my breath, while we tested on a few more machines, and everything calculated as it was supposed to. So, I changed the named range to a worksheet reference, using cells on the same worksheet. There was no obvious reason why that wouldn’t work in Excel 2010, but I was getting desperate.

They were SUMIF formulas that referred to a named range on another worksheet. So, I kept tweaking and testing, going through the file one worksheet at a time.įinally, I found the formulas that seemed to be causing the problem. I spent a considerable amount of time in Google, looking for other suggestions, but didn’t find anything new.

These formulas weren’t sleeping, they were deceased! Change the Named Range in the Formula Sometimes that brings a tired formula back to life, but not in this case. This has a similar effect to manually selecting a cell, clicking in formula bar and pressing the Enter key, to recalculate the cell. Next I wrote a macro that replaced all the “=” signs at the start of all formulas in the workbook.

#Excel for mac 15.36 not returning sum of cells full#

I also tried a macro that did a full calculation, and that didn’t work either. However, none of the shortcuts had any effect on the non-calculating cells in this workbook. We tried using the Calculation shortcuts, including Ctrl + Alt + Shift + F9 (that one recalculates everything, and starts your car). N the tooltip that is shown in the screen shot below, you can see that the shortcut for Calculate Sheet is Shift + F9. Or, go to the Excel Options window, and click Formulas.Įven if the Calculation option is set for Manual, you can use a Ribbon command or keyboard shortcut to force a calculation.Ĭlick the Formulas tab on the Excel Ribbon, and click Calculate Now or Calculate Sheet. To check the setting, click the Formulas tab on the Excel Ribbon, and click the Calculate Options drop down. In this case, the workbook calculation was set to Automatic on all the machines – that’s the first thing we checked. That setting affects all the other workbooks the you open during that session.

#Excel for mac 15.36 not returning sum of cells manual#

That can happen if the first workbook that you open in an Excel session was saved as Manual calculation. When someone complains about Excel formulas not calculating, it’s usually because the Calculation setting has been changed to Manual, instead of Automatic. Hint: It wasn’t one of the obvious solutions. Why are Excel formulas not calculating on some computers? Even more mysterious, the calculations worked fine on some machines, but not others.

#Excel for mac 15.36 not returning sum of cells update#

This should be the cell where you want to display the sum of these non-adjacent columns.What happens when good Excel formulas go bad? A workbook of mine that worked fine for several years, when using Excel 2003, suddenly refused to update all the formulas, after a switch to Excel 2010. Change the letters and numbers in parenthesis to fit your workbook.įinding the Sum of Numbers in Non-Adjacent Columns or CellsĬlick any empty cell in the workbook. Once you click, Excel will automatically add the sum to the bottom of this list.Īlternatively, you can type the formula =SUM(D1:D7) in the formula bar and then press “Enter” on the keyboard or click the checkmark in the formula bar to execute the formula. In that case, highlight the numbers you want to add.įrom the “Formulas” tab, click “Autosum” to find the sum of the list of numbers. Here, you’ll find the sum of any selected cell as well as their average and the number of cells you’re adding.īut, we’ll assume you want to add the sum to the workbook itself. The quickest way to calculate the sum of squares in Excel is to simply highlight the list of numbers, and check the bottom right of the screen. Finding the Sum of Numbers in Adjacent Columns or Cells