Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
midnight1
Contributor II

The sum function in sheets - auto option different from sum option

Hi, I don't understand what is the reason for the difference between the sum with auto function and the sum with sum function?

porównanie_auto i sum.png

I think that the sum function is more accurate, the auto option sometimes seems to be too big.

 

Labels (4)
1 Solution

Accepted Solutions
RohanD351
Partner - Contributor II

Hi @midnight1 ,

When you select Auto = it will evaluate the expression at an overall level & give the output, where as when you select Sum = it will evaluate only sum of the values present in the column. hence, Sum will give lower value than Auto.

 

Regards,

Rohan.

View solution in original post

1 Reply
RohanD351
Partner - Contributor II

Hi @midnight1 ,

When you select Auto = it will evaluate the expression at an overall level & give the output, where as when you select Sum = it will evaluate only sum of the values present in the column. hence, Sum will give lower value than Auto.

 

Regards,

Rohan.