Displaying a cumulative total

You can use the COUNT and SUM functions to perform a cumulative sum on a range of cells. This formula ignores empty cells or those cells that contain text. If a number is later added to an empty cell, the formula is automatically updated to include the new data. This is a useful function to know when you are working with the Target Value in a Gauge component.


Goal: Use the COUNT and SUM functions to display a cumulative total. 

SUM( SLICE( A2:L2 , 0 , COUNT( A2:L2 ) ) , data )