Forum Discussion
AutoSum not working
I've been using Excel with AutoSum for many years. Recently installed Office 365 and pre-existing spreadsheets are working as usual. Have just set up a brand new spreadsheet with lots of cells to a...
Why not? - you can
Hi Sergei - thanks for your reply.
I'm no expert but I have been using Excel for many years - many versions on many machines at home and work. I've always found Excel to be a bit flaky usually cured with a hard reboot when it goes weird occasionally (whine). This is the first time I've noticed a problem with merged cells. Maybe it's some anomaly on my machine? It's an i7 3.2 GHz with 16 GB RAM, 64 bit Win10 and Excel 2019.
I'm pretty sure I have used auto sum on merged cells in the past on different machines with different versions of software. I found on my new machine with a column of single cells I can highlight them and auto sum - no problem. However, if I merge 2 cells horizontally and then have a column of these merged cells - auto sum does nothing. No errors no action. Cells were formatted as currency in both examples.
Just a for-what-it's worth. I came across this out of my own frustration - didn't see it on Google which also seems weird like I'm the only one?
Hope that was helpful.
Bye
First, I'd do not recommend to use merged cells, especially horizontal ones, at all. Merged cells are root for many issues. Use Center Across Selection where possible.
For such sample
if autosum only merged cells, SUM takes entire range but result is correct since for merged cells values are kept in left most cells and others are empty.
If autosum mix of merged and not merged cells - yes, you need to adjust the range manually to use only left column where the values are.
