1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Same cells highlighted, different sums displayed

When I highlight cells, sometimes the sum shown in the bottom right corner of my screen is different.

I thought it was random and originally thought the math was "wrong" due to rounding issues.

Today I found that if I highlight in an upward motion it calculated differently than if I highlight the same 2 cells in a downward motion!

I recorded the screen in case I'm not explaining it well.

What is causing this and why would it be different? Is this actually a "feature" and not an "issue?"

submitted by /u/lsharris
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#highlight cells
#different sums
#sum
#upward motion
#downward motion
#calculating
#rounding issues
#different calculations
#math
#feature
#calculations
#recorded screen
#issue
#explain
#cells
#values