A feature that automatically detects and sums a range of adjacent cells.
Essayer avec l'IAAutoSum is a shortcut tool located on the Home and Formulas tabs that instantly inserts a SUM function for a selected range. It intelligently identifies the most likely range of data to calculate and can also be used to access other common functions like AVERAGE, COUNT, MAX, and MIN.
=SUM()If you have numbers in cells A1 through A10, clicking AutoSum in cell A11 will automatically insert '=SUM(A1:A10)'.
Press Alt + = on your keyboard to trigger the AutoSum feature.