Forum Discussion

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
Apr 09, 2019

Sum error Excel 2016 (Insider) Windows 10 Pro x64 (1809)

Having a weird error trying to sum a column of values. The formula is written so that if a key cell is empty (""), the array that the formula (-1) will be summed and the total appears in that cell. ...
excel
Formulas and Functions
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 10, 2019

John, I was not able to reproduce on a simple model. Are you on the latest Insiders build (1904.11601.20042)? Previous one was quite buggy.

 

TheOldPuterMan 

TheOldPuterMan's avatar
TheOldPuterMan
Brass Contributor
Apr 15, 2019

SergeiBaklan 

 

Sergei,

 

Yes, I am. In fact, the (one) reason I'm so slow in getting back is that I did a system reset and Microsoft left me in in a bad spot. The updated deleted ALL of my USB drivers and did not install any new ones.

 

I had to dig out my trusty old PS/2 keyboard and remember how to work my way through device manager with tab and cursor keys. I finally got a set of USB drivers installed for the mouse and then started rebuilding my system.

 

I didn't lose data but the past few days have been Interesting. On top of it my wife walked in with the chest/head cold from hades and had to share it with me. I've been down with that for the past 4 days and haven't done anything.

 

I appreciate your helpful suggestions and THINK I have an inkling to what's happening. 

 

I'll get back to you later, after more testing.

TheOldPuterMan

John

 

Resources