The SUM function is probably the most basic function you need in Excel. Walter Hickey BI You type in =SUM( and then select an array of values.

Excel has finally addressed this pain point with the introduction of a new function called SCAN.It’s designed to streamline calculations like running totals.